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: 
Anonymous
Not applicable

Help with calculation

Hi i am using a pivot table in Qlik Sense and have a table like below:

Total012

3

4

5
Total1577495201228132214307
A254101232875657
B3322012334344576
C303133424544534
D22112128353475
E467320123423465

The numbers are unit sales

The Letter are areas

I want it to look like this with the % calculation:



Totals012345
Total1577100%49531%20113%22814%1328%21414%30719%
A25416%101%121%322%876%564%574%
B33221%201%1238%342%342%453%765%
C30319%1338%423%453%40%453%342%
D22114%121%121%835%50%342%755%
E46730%32020%121%342%20%342%654%

What is the measure i need to write to divide the units by the total?

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

i have worked it out. Answer is =Sum(Sold)/Sum(Total Sold)

View solution in original post

1 Reply
Anonymous
Not applicable
Author

i have worked it out. Answer is =Sum(Sold)/Sum(Total Sold)