Pivot table percentage total not = to 100%

[jamie_lo75]

Can you kindly help me please!

So I made a pivot table, and the Grand Total for the percentage does not add up to 100% it is 101 when you account it in total 94+5+2=101, not 100

How can I fix it?

thank you

 

[Georgiboy]

Try setting the field to have 2 deciaml points for the % and see what the result is.

 

[jamie_lo75]

tried and still same

 

[Georgiboy]

So that adds up to 100.01 but I suspect only due to rounding. If you add more decimal points you will see what I mean.