Sum of amounts but exclude 2 dimensions

[chriscools]

Hello,

i want to make an overwiew table in which to monitor total sales per shop.

but since we have 2 testshops i don't want to include them in the table.

as an expression i found to do it like this:

Sum (if (shop <> Testshop, LineSalesAmount))

But that does not work, it gives me nothing.

i also tried it like this:

Sum (if (shop <> 'Testshop', LineSalesAmount))

but that also didn't work...

what do i do wrong?

and how should i exclude a second one?

thanx!

chris

[MayilVahanan · Accepted solution]

Hi,

     Try this,

     =Sum({<Shop -= {'Testshop'}>}LineSalesAmount)

     Can you post a sample.. or what is the second one..

        =Sum({<Shop -= {'Testshop','Testshop2'}>}LineSalesAmount)

Hope it helps..

[chriscools]

Hello,

thank you very much for your reply, it works perfect!!!

thanx!!

chris