Yes, for e.g. lets say direct and indirect costs are at parent level and they reside in one column (i.e level2). Then we have children for direct as expenses, salary and children for indirect cost are subscription and fee listed in another column (i.e. level3) . We have a measure column(i.e. Amt) which are the values associated to it.
In qliksense pivot, we can add more than 1 dimension and measure, so here we add level2 column as first dimension and level3 column as 2nd dimension and add a measure sum(Amt).
The output of pivot, will display 2 values direct and indirect cost grouped and collapsed, if you click on this dimension, it will further expand and give you the breakup of direct and indirect cost.
Similary you can add dynamic columns to qlik sense pivot, very similar to a pivot in excel.
