Excel - Pivot Table Partial Column %

  • Thread starter Thread starter carlo
  • Start date Start date
C

carlo

Is possible calculate into a Pivot Table a partial total % in column?
Se the item with red color

es.

Key1 Key2 Qta *% part.* % tot

AAA item 1 90 *90%* 45%
item 2 10 *10%* 5%
AAA Sum 100 100% 50%


BBB item 3 1 * 1% * 0,5%
item 4 99 * 99%* 49,5%
BBB Sum 100 100 50%


TOTAL 200 100% 100
 
Set up your pivot table with Key1 in the column area, Key2 in the row
area, and Qty in the data area.

Add another copy of Qty to the data area.
Right-click on the field heading for the new field
Select Field Settings
Click the Options button
From the 'Show data as' dropdown, choose % of Column.
Click OK
 
Back
Top