Pivot Table

Hi,

It sounds like you've included totals on the source data so when you total your pivot table it's including them, and therefore you get double counting.

The easiest way to fix this is to change your source data. Either take the totals off the original data OR change the cell range which is coming into the Pivot table so it doesn't include the totals.

Hope this helps,

Claire

Hi,

If this is the problem, and you have totals in your source data, then you need to set your source data to exclude them.

Because the numbers could change there is no "balancing calculation" that you could reliably apply.

Changing the source data range feeding the PT is probably best for you as you can leave the totals in the original data.

All data that goes into a PT must be in its simplest form and should not include any summary data.

thanks
Claire