Calculate Column % in Pivot Table

deekey2 — Fri, 05 Nov 2021 06:24:54 GMT

Hi All,

I have a table as below:

And I made a pivot table (X:Type / Y:Category) , which sum the QTY like this:

Then I would like to convert as % by each column.

I tried to use: sum(QTY) / sum(total QTY)

but the part "sum(total QTY)" returns 772 (total of all QTY)

I tried and worked for hard code like:

sum(TOTAL if(Type='D', QTY)),

but if I get dynamic like:

sum(TOTAL if(Type=subfield(type,',',1), QTY))

it returns 772 again..

Any ideas? thanks

Re: Calculate Column % in Pivot Table

MayilVahanan — Fri, 05 Nov 2021 09:37:23 GMT

Try like below

sum(QTY) / sum(total<Type> QTY)