Partial Sums in straight table | Custom Labels in Pivot SubTotals



    Recently I have seen some threads where people have been asking for Partial Sum's / Sub Totals in a straight table.

    Immediate first thought was Why Oh Why! we have a Pivot table to do just that! But there are a couple of benefits I liked when creating the solution.




    What I liked:

    1) Custom Labels for Subtotal , as you can see above

    2) Clicking on the Subtotal Collapses the inner dimensions, YAY!   Whereas the same with a Pivot table will be a two step process   that is Right Click >> Collapse All




    Happy Qlik'in





    Vineeth Pujari