1 Reply Latest reply: Jul 9, 2018 4:11 PM by Tom Hassall RSS

    Help with calculation

    Tom Hassall

      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?