Hi all, I'm very confused about what is going on with my pivot table.
The row&column totals are correct but the underlying cell values within the table are only showing a value from one part of the sum instead of the entire sum? What's worse, when I drill down, it shows the correct sum
Tried moving to a Mega Table and the readability is just not the same.
My next guess was to create a rollup dataset and nix the drill down capability altogether
Appreciate you all