Hi- I have created a pivot table and want a % calculation on a row. I can not use calculated fields as it is an item in a field and I can not used calculated items as the items are in two different fields.
For anyone financially minded it is a gross profit %. I have my pivot displaying total income and gross profit (totals) and therefore need gross profit divided by total income to give me a %- but I am working vertically which seems to be a problem.
Thanks,
Dimity
For anyone financially minded it is a gross profit %. I have my pivot displaying total income and gross profit (totals) and therefore need gross profit divided by total income to give me a %- but I am working vertically which seems to be a problem.
Thanks,
Dimity