Hi All

I dont think this is possible, and give up even trying now but.......

Can i calculate rows in a pivot table? and also keep the format of a cell locked to the heading of the row?

Basically im looking at quantity (numeric), sales (£), gross profit (£) and gross profit (%)

As we all know pivots sum the total of the data it is looking at, which is fine for the first 3, but for the % i need it to do the calculation gross profit divided by sales. I can get this in a calculated field, but my pivot has these "measures" in the rows, not the columns

Period (All)
Hemisphere (All)

Measure Sum of Actual Sum of Last Year
Actual Sold Qty 4,639,821 6,588,769
Net Sales Amount £65,302,872 £84,059,859
GROSS MARGIN £4,701,211 5584394.804
GM% -139.2% -136.8%
Grand Total

So above the GM% is a sum of my data, but i want it to calculate the above mentioned.

Is this possible? and also if say this ranges from cell a5-d9, if the pivot is refreshed and new rows are inserted how can i make sure certain rows are numeric, currency or percentage?

As i said i have given up so this is my last shot, any help, or even someone telling me it cant be done would be great