Grand Total Percentage not equaling up to 100%

[jnickson]

Here is my problem, i have this setup that adds all the sum values 

Then i am changing the second column as a percentage ..

Heres the result

All of those percentages added up equals about 91% ish not 100%

[AilleryO · Accepted solution]

Hi,

Do you have any filters active ?

Is your Overall Total Cost only the Sum of a Column, or is it a calculation you made ?

Basically just remember that the total at the bottom of your column, is not a sum of the numbers above,

but a calculation of percentage made without the filters (data) being on the lines of your visual.

So the total divided by himself, gives 100% most of the time 😉

Tell us more, so we can help you.