My approach would be to create grouping dimensions with subtotals also being a dimensions in qlik data model and use straight table to plot it. You would normally use the same approach to create grouping dimensions in P&L reporting...
Can you share draft of your required output. Important is to understand how many dimensions you will have in your output table (in html)
thanks
Lech
cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.