Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

tomhassall
New Contributor II

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
tomhassall
New Contributor II

Re: Help with calculation

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

1 Reply
tomhassall
New Contributor II

Re: Help with calculation

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

Community Browser