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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average of Subtotals in Pivot Table 0
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Pivot Table static columns 4
Pivot Table Field based on two data area fields 3
Summing Problem In A Pivot Table 1
Pivot Table Calculations 2
Data Grand Total in Pivot Table Row Area 1
How to ignore a column of numbers in Grand Total for rows 1

Back
Top