Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register 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