Excel - Pivot Table Partial Column %

[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

 

[Debra Dalgleish]

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