Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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]))