Pivot Table Calculations

  • Thread starter Thread starter Shua
  • Start date Start date
S

Shua

I'm trying to do a simple addition calculation within a
pivot table (sum two rows of the diplaying pivot table
data) and the answer I'm getting refers back to the raw
data of the pivot table (takes the average of each row and
then the sum). By referencing the raw data, the total is
off. Does anyone know how to get around this?

Thanks in advance.
 
You could do the calculations outside of the pivot table, using cell
references or GETPIVOTDATA to extract the values.
 
Back
Top