I have data that looks like this:
Closed | Type
1 | Type A
0 | Type A
0 | Type A
1 | Type B
0 | Type B
I'm hoping to be able to display in a Pivot Chart:
Type A 33% (out of 3 Type A's, 1 is closed)
Type B 50% (out of 2 Type B's, 1 is closed)
I have data that looks like this:
Closed | Type
1 | Type A
0 | Type A
0 | Type A
1 | Type B
0 | Type B
I'm hoping to be able to display in a Pivot Chart:
Type A 33% (out of 3 Type A's, 1 is closed)
Type B 50% (out of 2 Type B's, 1 is closed)
Can you please attach your sample file with the pivot so that we dont have recreate the file?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
add a new column (called All) to the data with 1 in every row then create a calculated field that is = 'Closed' / 'All'
Josie
if at first you don't succeed try doing it the way your wife told you to
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks