LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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,
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
More Assistance Needed with Pivot Tables Michelle Excel Discussion (Misc queries) 1 August 14th 07 11:05 PM
Pivot table assistance Barb Reinhardt Excel Discussion (Misc queries) 1 April 26th 07 01:52 PM
Pivot Table Assistance Needed Barb R. Excel Worksheet Functions 4 May 11th 05 05:11 PM
Pivot Table Assistance Needed Barb R. Excel Worksheet Functions 0 May 11th 05 02:51 PM
Pivot table assistance Deb Excel Discussion (Misc queries) 3 April 22nd 05 07:40 PM


All times are GMT +1. The time now is 06:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"