how to exclude records from chart expression

[maart]

hi,

I have a table with 3 fields regarding expenses: date, category and amount. There are 6 categories of expenses.

In a chart having the date as dimension, I would like to set the expression as a sum of the amounts but excluding one or the category (salary expenses) and including just the other 5.

Thanks

[mongolu · Accepted solution]

Salve.
I see you are a fellow romanian.

You could try the if sentence:
SUM( IF(Category<>'Salary expenses',Amount) )

or the Set Analysis:
SUM( {$< Category -= {"Salary expenses"} >} Amount ).

[maart]

Salut Mihai,

I am glad that you replied me.

Your answer solved my issue. I used your first suggestion. As for the second, didn't worked the same, don't know why. Not familiar with Set Analysis.

Many thanks,

Marius