Pivot Table Grand Total wrong when using Formulas

J

John P

I used a Formula in a Pivot Table and the the total for the formula Column
is INCORRECT as it reflects only one portion of the formula. My formula is
an "if statement" that if one field is "0" use the other preexisting field.
Is there a way to have the total reflelct all amounts and not just the total
of certain amounts??
 
D

Debra Dalgleish

Perhaps you could add a column to the source data, and do the
calculation there. Then, add that field to the pivot table.

Or, try changing the pivot table formula so it adds the two items,
instead of using an IF formula.
 
J

John P

The source data is updated from our accounting database and when the data
is updated all fields not coming from the database are eliminated.

It is an either or not a summation.

The main question is why would Excel allow you to create formulas, put the
correct amount in the column, but when Excel calculates the Grand Total in
the Pivot Table it calculates a WRONG Amount for the Total
 

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

Pivot table grand total location 1
Grand total sum of formula 6
Calculating total amount in a Pivot Table 1
calculate grand total 2
Need the grand total pivot table filtered worksheet? 1
Pivot Table Count 1
Pivot Table (Grand Total) 1
Pivot Table Grand Total for Rows not functioning 1

Top