how to calculate percentage with consistency in pivots
I have financial data over a period of time for which I need to calculate Ops cost as % of revnue
My problem is depending up the period I look at the percentages add up differently that is month, year and global
I want the calculation to be consitant that is sum months to year and months to global and year to global
Please see attached file for sample data
Please also need a pivot chart with the Ops cost as % of revenue in secondary axis
Thanks,
Izhar
I have financial data over a period of time for which I need to calculate Ops cost as % of revnue
My problem is depending up the period I look at the percentages add up differently that is month, year and global
I want the calculation to be consitant that is sum months to year and months to global and year to global
Please see attached file for sample data
Please also need a pivot chart with the Ops cost as % of revenue in secondary axis
Thanks,
Izhar