0 Replies Latest reply: Aug 30, 2018 9:59 PM by Shirley Kwan RSS

    Add subtotal to table

    Shirley Kwan

      Hello,

       

      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!