Subtotal (subtraction) Rows instead of subtotal (addition) Rows in Pivot Table

hamza_123
hamza_123 Contributor

Right now there is an option to include subtotals in pivot tables. Can we include subtration of rows instead of subtotals? 

 

I have two rows: Current Week and Previous Week. I want to add a subtration field in the rows. 

 

 

Can anyone help

Best Answer

  • Neeti
    Neeti Member
    Answer ✓

    Hi,

     

    You can create beast mode as below which works row wise, beast mode is nothing but creating a calculated filed:

     

    'Current Week' - 'Previous Week'

     

    Drag the calculated filed in your pivot table to see the result.

     

     

     

    **Say "Thanks" by clicking the "heart" in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"

     

    Thanks,

    Neeti

Answers

This discussion has been closed.