Pvt Tables - Custom Calculations - HELP ME!!

[Healthya]

I have a simple chart where I want to calculate my costs as a percentage of
revenue. So, I basically only want to see three or four columns: Clients,
Revenue, Cost, Cost %.

Can the pivot table calculate this percentage?? Cost / Revenue = %

Please Help!!!

 

[Ashish Mathur]

Hi,

You can write a calculated field formula in a pivot. While you are on any
cell in the pivot, on the pivot table toolbar, click on the pivot table drop
down button and go to formulas > Calculated filed. In the name box, type in
Percentage. In the formula bar, type =cost/revenue

This will insert a field in your pivot table called Percentage. You may
format is as %

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com