Data Fields:

Amount
Field settings:
Summarize by Sum
OPTIONS =
Show Data as :
% of column





--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Glenn E. White wrote :

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,