Question

[#1]

Hi,

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?

[sinanozdemir]

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.