I have a pivot table where people can apply various slicers to filter the data. The grand total does not equal the sum of the column totals. In some cases, the row totals do not match the grand total either.
See example attached - this is a very strange anomaly I have not come across before, what could be the cause??
Screenshot Pivot.png
Bookmarks