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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
anuradhaa
Partner - Creator II
Partner - Creator II

Add Sums to Pivot Table

I have created attached pivet table.

I want to add presentages in to that table.

pls help me to do that

Labels (1)
1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

The percentages can be calculated with sum(Value)/sum(total <Destination> Value). Change Destination and Value with the names of your fields.


talk is cheap, supply exceeds demand

View solution in original post

4 Replies
Not applicable

Hi,

Has no attachment.

Rebeca

anuradhaa
Partner - Creator II
Partner - Creator II
Author

Forgot add the attachement. pls find it below.

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

The percentages can be calculated with sum(Value)/sum(total <Destination> Value). Change Destination and Value with the names of your fields.


talk is cheap, supply exceeds demand
anuradhaa
Partner - Creator II
Partner - Creator II
Author

Thanks Gysbert.