Skip to Content
0
Aug 13, 2015 at 05:25 PM

Condition to filter out rows

33 Views

Dear Community,

I'm having the below query:

I'd like to filter out all rows that meet the condition "Balances = 0".

This shall only be applicable to the last three years.

The expected outcome would be that the red marked rows are being filtered out.

I have been testing pretty much all possible combinations in the "Characteristic Assignment", but I cannot seem to achieve it.

Is there any way to do this by means of the Query Designer?

Many thanks for your help!

T

Attachments