Hi,.
i am new to this so please excuse if this is incorrect way to ask for help.
I am using a pivot table with financial data inc Sales, Costs, Margin % and % of total
I need to add a Calculated field which will allow A calculation using each row of the % of total Vs the grand total of margin %.
Sum is % of total*(line items Margin % - Company Margin %). This will allow for a Margin Impact % to be calculated.
As the % of total is purely a measure of sales % of each row and not a caculated field i cannot see the % of total to use in the forula of the new Cacl field.
sorry if this is not clear quite hard to put this into writing.
Regards
Simon S
Bookmarks