Grand Total of Calculated Items in a Pivot Table Incorrect

I think this may be a case where the percentage of the sum does not equal to the sum of percentages. For example, (1+3)/(10+4) does not equal (1/10)+(3/4). The key is determining which percentage is more meaningful to your analysis. Are you more interested in the percentage within a group or across all groups? I do not have an answer to your question, since only you know which percentage calculation is more relevant to your analysis.

My comment here is more to reveal to you why the pivot table is giving you the numbers it is. So, in the case where responded chose "1 - Extremely Unsatisfied", note the following:

First Case: Percentage of the Sum
(2+1+2)/(9+12+9+3+3+10+4+5) = 5/55 = 9%

Second Case: Sum of the Percentages
(2/9) + (0/12) + (0/9) + (1/3) + (0/3) + (2/10) + (0/4) + (0/5) = 22% + 0% + 0% + 33% + 0% + 20% 0%= 76%.

One would be very surprised if these two percentages did turn out to be equal. In fact, in the First Case, the final percentage is always less than or equal to 100%. In the Second Case, it is very possible for the final percentages to exceed 100% (which is not a very meaningful way to look at the numbers). So I would recommend ignoring the grand total cells in your pivot table that show the following percentages: 76%, 145%, 130%, 281%, and 168%.

Hope this helped a bit.

_______________________________
1. If this reply was helpful, please click the star to the left of this reply.
2. If this reply solved your question, please mark this thread as [SOLVED].