Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi i am using a pivot table in Qlik Sense and have a table like below:
Total | 0 | 1 | 2 | 3 | 4 | 5 | |
---|---|---|---|---|---|---|---|
Total | 1577 | 495 | 201 | 228 | 132 | 214 | 307 |
A | 254 | 10 | 12 | 32 | 87 | 56 | 57 |
B | 332 | 20 | 123 | 34 | 34 | 45 | 76 |
C | 303 | 133 | 42 | 45 | 4 | 45 | 34 |
D | 221 | 12 | 12 | 83 | 5 | 34 | 75 |
E | 467 | 320 | 12 | 34 | 2 | 34 | 65 |
The numbers are unit sales
The Letter are areas
I want it to look like this with the % calculation:
Totals | 0 | 1 | 2 | 3 | 4 | 5 | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 1577 | 100% | 495 | 31% | 201 | 13% | 228 | 14% | 132 | 8% | 214 | 14% | 307 | 19% |
A | 254 | 16% | 10 | 1% | 12 | 1% | 32 | 2% | 87 | 6% | 56 | 4% | 57 | 4% |
B | 332 | 21% | 20 | 1% | 123 | 8% | 34 | 2% | 34 | 2% | 45 | 3% | 76 | 5% |
C | 303 | 19% | 133 | 8% | 42 | 3% | 45 | 3% | 4 | 0% | 45 | 3% | 34 | 2% |
D | 221 | 14% | 12 | 1% | 12 | 1% | 83 | 5% | 5 | 0% | 34 | 2% | 75 | 5% |
E | 467 | 30% | 320 | 20% | 12 | 1% | 34 | 2% | 2 | 0% | 34 | 2% | 65 | 4% |
What is the measure i need to write to divide the units by the total?
i have worked it out. Answer is =Sum(Sold)/Sum(Total Sold)
i have worked it out. Answer is =Sum(Sold)/Sum(Total Sold)