in-line subtotaling of dimensional elements

[TheQlikBrownFox]

Within Qlik, is it possible to group dimensional elements with in-line subtotals without the use of creating an additional dimension and perform this with a single column/ dimension? Below is a mock-up example of what I'm looking to functionally replicate.

[Vegar]

I did something similar in this blog post. It is not exactly what you are trying to do, but it might give you inspiration to solve your needs.

http://aqlik.se/2019/01/sub-totals-in-a-qlik-straight-table/

[TheQlikBrownFox]

Thanks for the link!  Very informative! I tried the approach of defining the parent dimension (Area) on the load script to separate the Departments into groups, then disabled subtotals on the "Expressions" tab, and enabled subtotals as indicated in the picture below. I was then going to hide the Area dimension from display, which *should* give the display once the subtotal definitions are correct. Can you please assist on what I am doing wrong with the subtotals as they are generating a line for each department instead of for each area. 

[Brett_Bleess]

@Vegar  Just flagging this for you in case the notifications in Community are still not letting you guys know when folks reply back, there was a further question on this related to your link, hopefully you may have a little more guidance on the last piece.  Thanks in advance as always for the help!

Cheers,
Brett

[Vegar · Accepted solution]

It doesn't look like the total expression is picking up the dimension per total row, it looks like the total header is calculated outside of the chart. You will need to do another approach to get the Area header on the row. 

I've prepared an example that could be of help. It is inspired of one of the solutions in my blogpost. 

[TheQlikBrownFox]

@Vegar , thanks! I'm used to other BI reporting tools where there is a limitation in the ways you can calculate in both rows and columns, so it's interesting to see how Qlik supports this much more openly.