Add Gross Margin line to a pivot table

This is quite kludgy. It uses formulas instead of a pivot table which means that the results are fixed.

I extended the formulas to cover the range M:Z.

First I got the minimum and maximum values for the period. This information is used to fill in the period information on row 1. I start with the minimum period number in cell N1 and then the rest of the formulas are =IFERROR(IF(N1+1>PerMax,"",N1+1),"")

The Turnover is =IF(N1="","",SUMIFS(Table_Data[[AMOUNT ]],Table_Data[[nominAL ]],"Turnover",Table_Data[[Period ]],N$1))
The Cost of Sales is =IF(N1="","",SUMIFS(Table_Data[[AMOUNT ]],Table_Data[[nominAL ]],"Cost of Sales",Table_Data[[Period ]],N$1))
Gross Profit is =IF(N1="","",N2+N3)
Percent is =IF(N1="","",N4/N2)

The totals are off to the left
Turnover is =IF(K1="","",SUMIFS(Table_Data[[AMOUNT ]],Table_Data[[nominAL ]],"Turnover"))
Cost of Sales is =IF(K1="","",SUMIFS(Table_Data[[AMOUNT ]],Table_Data[[nominAL ]],"Cost of Sales"))

The other two formulas remain the same.

As presented this spreadsheet is good M:Z. You can "extend the first 5 rows of formulas for as many columns as you need.