K
Karen53
Hi
I have a pivot table wth a field in the column area containing two values,
yes and no. My data is then filterd to these two columns. I have created a
calculated item adding the yes and no for a total people. I created another
calculated field to compute the percentage of 'yes' to the total people. I
have turned off the row grand totals. My column sub totals snd grand totals
are not giving me acurate percentages for the data in the fields. Am I
missing something?
Yes/No
No Yes Total Percentage
Person1
Sub total person1
person2
sub total person2
person3
sub total person3
Thanks for your help in advance.
I have a pivot table wth a field in the column area containing two values,
yes and no. My data is then filterd to these two columns. I have created a
calculated item adding the yes and no for a total people. I created another
calculated field to compute the percentage of 'yes' to the total people. I
have turned off the row grand totals. My column sub totals snd grand totals
are not giving me acurate percentages for the data in the fields. Am I
missing something?
Yes/No
No Yes Total Percentage
Person1
Sub total person1
person2
sub total person2
person3
sub total person3
Thanks for your help in advance.