Pivot Table % Cal Issue

subbareddykm — Sat, 16 Nov 2024 01:31:22 GMT

HI All,

i am wondering how to caluclate the % on column level 100% in Pivot Table.

Its not giving me the column level % but its giving me the oveal %.

Can any one tell me how to achieve the below one

Re: Pivot Table % Cal Issue

jonathandienst — Tue, 14 Jan 2020 04:43:16 GMT

Something along the lines of:

Sum(Amount) / Sum(TOTAL <Month> Amount)

This called a partial total and its much like the subtotals in a pivot table