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

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
    Accepted 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.