• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Pivot Table Subtraction Question

PaulF

Active Member
Hello all!

I have a Database (list) that contains projection and actuals and can get a nice subtotal as needed. I would like the grand total to be the difference between the subtotals, not the sum...

Am I blind or ??

Respectfully,
PaulF
 
How is your PivotTable made?

1. Using Excel Range/Table as data source
2. Standard PivotTable, but made using data model
3. Using PowerPivot data model

Also, what version of Excel do you use for this?

It would help if you can upload sample workbook that mirrors your set up (with sanitized values). And also put manually created expected output in the workbook.
 
Std PivotTable from Table as source.
 

Attachments

  • Chandoo_Pivot_GT_Diff.xlsb
    442.4 KB · Views: 5
Unfortunately, you can't do it in PivotTable alone in this case.
What I would do... is to add calculation above the pivot table (to avoid over-writing formula when pivot range is extended).

How dynamic do you need this to be? Should it extend to entire column(s) when pivot is fully extended? Or just needed for Monthly level?

Using PowerPivot, you can create dynamic measures that will appropriately fill each field.
 
Back
Top