View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Glenn E. White Glenn E. White is offline
external usenet poster
 
Posts: 1
Default Need Assistance With Pivot Table Please

I have a pivot table setup as follows:

Row:
Category
Item Name
Product ID

Data:
Unit Sales
Sales Amount
Average Unit Sales
Average Unit Price

How can I get the percentage of the total category unit sales for each item
name? Basically the layout would be:

Category - Item Name - Product ID - Unit Sales - Sales Amount - Avg Unit
Sales - Avg Unit Price - % of Total Category

Any assistance or direction that you can provide will be greatly appreciated.

Sincerely,