Discussion board where members can get started with Qlik Sense.
I've got two tables:
I'm strugling for a couple of hours to get the next result:
Could anyone give me a hint to get a sum in the lines 199, 299 and 399.
199 should be the sum of account 100>120
299 should be the sum of account 200>220
399 should be 199 + 399
Is this easy to do in QS?
It is possible if you already have "A-Total", "B-Total", and "TOTAL" rows in place in your data model. You can use RangeSum() with Above() to achieve this:
Take a look at my expression.
Hope it helps.