Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Ronald
Contributor III
Contributor III

Pivot Table sum dimensions

Hi, I have my pivot(dim1 Prod, dim2 Esp), but want repeat sum Mat0  value  in col Tot; % =Mat0/Tot

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

 

pivot.png

Labels (2)
3 Replies
jyothish8807
Master II
Master II

Hi Ronald,

Can you please explain your requirement a bit more ? A sample data and expected output sample will be helpful to understand. 

Best Regards,
KC
Ronald
Contributor III
Contributor III
Author

Hi, good mornig.

I need %P1 = 11/91

91 is sum horizontal for Esp1

11 is Mat0 value 

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

 

Ronald
Contributor III
Contributor III
Author