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,

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,

There's no option to calculate the percent of a subtotal in a pivot
table. You could do the calculation outside of the PivotTable.

Or, create a second pivot table, based on the first one, and use the %
Of Column calculation to show the category percentages. There's an
example he

http://www.contextures.com/xlPivot10.html


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,


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html