$$Excel-Macros$$ Pivot Table Help - Gross Margin % & % of Sales

Hello, I have a challenging pivot table issue that I hope I can get some help on. Here is the spreadsheet I'm working with: https://www.yousendit.com/download/OHo0N3RSSU90d0UwTVE9PQ I'm having problems with showing percentages in my pivot table such as gross margin and operational profit. Here

Re: $$Excel-Macros$$ Pivot Table Help - Gross Margin % & % of Sales

Guru, I actually want to see both of those line items as percentages of sales which is to say, take gross margin $ and divide it by sales. Same for operating income. Thanks! -- -- Some important links for excel user

Re: $$Excel-Macros$$ Pivot Table Help - Gross Margin % & % of Sales

here you go http://www.mediafire.com/download.php?nvt1ymtzjdy thanks for your help! -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2