Pvt Tables - Custom Calculations - HELP ME!!
 

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!!!

Pvt Tables - Custom Calculations - HELP ME!!
 

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

"Healthya" wrote in message
...
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!!!