Calculation in Pivot table

[haitham.shop]

Hi Exceler,

How can I add column to make calculation in pivot table? for example in the figure, How can i dived total upon unit?

Please Help ,,,

[shukla.ankur281190]

Drag once more Units in to Value then right click on newly created column go to show value as and you will get too many option but you must select % parent row total.

Hope it will help you

[xlnitwit]

Hi,

You actually need to show values as the % of column total.