Hello everyone
I have a pivot table where I moved the Section to the rows and the Branch to the columns and the Sales to the values.
I would like to add a new row after the revenue and cost of sales in the rows that called gross profit
which is revenue less cost of sales,
According to the picture I attached between rows 6 and 7 in the Pivot Table..
How do I do this in Pivot Table?
Thanks for the help
I have a pivot table where I moved the Section to the rows and the Branch to the columns and the Sales to the values.
I would like to add a new row after the revenue and cost of sales in the rows that called gross profit
which is revenue less cost of sales,
According to the picture I attached between rows 6 and 7 in the Pivot Table..
How do I do this in Pivot Table?
Thanks for the help