Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor II

Add subtotal to table


I have created a simple pivot table with 2 dimensions and with their sub-total and grand total in QS. However, my client doesn't like the total to be on the top. Thus, I am trying to build a straight table with the same information displays.

Below is the example for your reference:

Source table:

Category     Sub-Category     Item     Sales

CatA          SubCat1               A          $100

CatA          SubCat1               B          $50

CatA          SubCat2               C          $80

CatA          SubCat2               C          $200

CatB          SubCat3               D          $400

CatB          SubCat4               E          $600

Result table:

Category     Sales

SubCat1      $150

SubCat2      $280

CatA Total   $430

SubCat3      $400

SubCat4      $600

CatB Total    $1000

Grand Total   $1430

Rather than pre-calculate the sub-total in script, may i know if it is possible to do it on UI?

Thanks in advance!

Community Browser