How to get % of column total in QlikSense

[kj22]

Hi members,

I am trying to obtain a measurement in pivot table in QilkSense, where I wanted to get % of column total.

In the pivot table in QlikSense, I am using ProdSub and Month-Year as two dimensions.

In the measurement, I wanted % of the column total.  Similar to as shown in the attached screenshot in excel.

When I try to use Total in the denominator, it is giving me value of % of row total (instead I wanted % of column total).

I would really appreciate you help....thank you so much.

[Luisanabria]

Hi, l understand what you want is something like this

If that is what u want, l use in my case this:

max(Aggr(sum([Amount Mn Bruto SKU]),[Executive DetFac])) /Sum(Total([Amount Mn Bruto SKU]))