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
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"
You can also try: