This content has been marked as final. Show 2 replies
Whenever I hide a column in a Pivot Table, any duplicated data that was in that column is now, not totaled up for example:
I have some entries that go something like this:
However, when I minimise x1682, the second two -1510416.67 and the first -1197916.67 is not calculated into the final total (which should be -6975000) I get -2756250. Note: there is no DISTINCT in the formula.
Has anyone else experienced this before and is there a way around it?
Thanks for your help in advanced