# Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for
Search instead for
Did you mean:
Highlighted
Contributor II

## Pivot Table column Percentage

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

Labels (2)

5 Replies
Highlighted
MVP

## Re: Pivot Table column Percentage

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

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

Highlighted
Contributor II

## Re: Pivot Table column Percentage

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

## Re: Pivot Table column Percentage

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)``````
Highlighted
Contributor II

## Re: Pivot Table column Percentage

Hi, good mornig.

I need %P1 = 11/91

91 is total horizontal for Esp1

11 is Mat0 value

Highlighted
Contributor II