Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Is there a way to display data like I've shown it below. In case it is
unclear, I'd like to calculate a percentage of sales of size 1 to the total sales of the various sizes of a product. For example, Prod A, size 1, as a percentage of total sales of Prod A, sizes 1-3. Product Size Units % A 1 100 16.7% A 2 200 33.3% A 3 300 50.0% A Total 600 100.0% B 1 150 20.0% B 2 350 46.7% B 3 250 33.3% B Total 750 100.0% Total 1350 100.0% |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Blank Cells in Pivot Tables | Excel Discussion (Misc queries) | |||
Macro for Pivot Tables | Excel Discussion (Misc queries) | |||
Product Function in Pivot Tables from Multiple Consolidation Range | Excel Worksheet Functions | |||
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) | |||
pivot table - hide details but show subtotal for calculated field | Excel Discussion (Misc queries) |