I need to add the following formula in a calculated field into a pivot to provide me with some rate and mix calculations.
=(sales x (Margin% - Total Margin%))-(Sales / Total sales) and so on...
Total above is the grand total for the column. All the above items are on my pivot via a local source data. However I can't figure out how to divide a cell by the grand total for for that column.
I am using Office 2010 64 bit on Windows 7. Any guidance would be greatly appreciated.
Regards
=(sales x (Margin% - Total Margin%))-(Sales / Total sales) and so on...
Total above is the grand total for the column. All the above items are on my pivot via a local source data. However I can't figure out how to divide a cell by the grand total for for that column.
I am using Office 2010 64 bit on Windows 7. Any guidance would be greatly appreciated.
Regards
