Partial Sums in straight table | Custom Labels in Pivot SubTotals

    Hi

     

    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.

     

    Pivot_CustomLabels.JPG

     

    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


          CollapseDimension.gif

     

     

    Happy Qlik'in

     

    Cheers

    Vineeth

     


    Vineeth Pujari