Visualization Total function is not correct...need help

[codyraptor]

I have a simple matrix visualization.  My value is a distinct count Dispatch.  The individual rows are accurate...but the sum of the column is losing values for some reason.  Example shown below.  If I total the column..it should be 75,128...not 72,818.  I'm using the simple 'Total' function.  Is this a bug..or could it be something with my data.  I'm lost on this one.

[KHorseman · Accepted solution]

If it's a distinct count, it may be that some of whatever column you're counting is counted in more than one of the Days Developed rows. The Total row isn't simply a sum of all the rows above; it's a calculation of the base formula for all rows.

Take this data for example:

code	name
furnace	Bucky
seventeen	Wanda
nine	James
furnace	Scott
daybreak	Steve
benign	Wanda
benign	Bucky
freight car	Clint
seventeen	Natasha
daybreak	Natasha
benign	Clint
rusted	Natasha
daybreak	Bucky
freight car	James
freight car	Steve
longing	Steve
nine	Wanda
benign	Peter
benign	T'Challa
daybreak	Peter
furnace	Steve
furnace	Wanda
one	Clint
rusted	Scott
rusted	Sam
daybreak	James
one	James
freight car	Clint
longing	Bucky
seventeen	T'Challa
...	...

My sample table is bigger than this but you get the idea. There are 11 names and 10 code words. The 10 words are distributed such that each name and each code appear together at least once. If I lay out the names with a distinct count of codes I get this:

Clearly that total is wrong if you just try to add 10 + 10 + 10 + 10 + 10 + 10 + 10 + 10 + 10 + 10 + 10, but a distinct count total isn't a sum of its parts. It's a distinct count of all, without the filtering contexts of the rows above. There are 10 code words, so a total distinct count is 10. In your data, I suspect there are a total of 72,818 distinct items to be counted, and some of them can be counted for more than one Days Developed value.