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

hamza_123

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

Neeti

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

Neeti

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

Neeti

You can also try:

 

https://knowledge.domo.com/Prepare/Magic_Transforms/ETL_DataFlows/02ETL_Actions%3A_Edit_Columns