Pivot Table column Percentage

[Ronald]

Hi need the percentage of my Column; the dimensions are Prod, Esp, but the dimension Tot is created; the total for Esp1 is 91, the percentaje is 11/91

[sunny_talwar]

What is the expression for Mat0? Assuming it is Sum(Measure), you can try this

Sum(Measure)/Sum(TOTAL <Esp> Measure)

[Ronald]

Mat0=Sum({<Mes={'M24','M23','M22','M21','M20','M19','M18','M17','M16','M15','M14','M13'}>} Px)

[sunny_talwar]

Try this

Sum({<Mes={'M24','M23','M22','M21','M20','M19','M18','M17','M16','M15','M14','M13'}>} Px)/
Sum(TOTAL <Esp> {<Mes={'M24','M23','M22','M21','M20','M19','M18','M17','M16','M15','M14','M13'}>} Px)

[Ronald]

Hi, good mornig.

I need %P1 = 11/91

91 is total horizontal for Esp1

11 is Mat0 value

[Ronald]

Hi good morning, I need something like this :
https://community.qlik.com/t5/New-to-Qlik-Sense/Calculating-Cumulative-Percentage-of-Total-by-Column...