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

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 ✓



    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"





This discussion has been closed.