Clients without sales in the previous year

[#1]

Hi to all!

I just have a little Question.

If I would show all Clients without sales in the previous year, how could I do this?

I thought this way:

If client sales previous year = 0 then show the Client sales from the actually year.

But it doesn't functionate.

Could anyone help me?

With many thanks

Dominik

[alexandros17 · Accepted solution]

Create a straight chart

Dimension : Client

Expression: If(Sum({$ <year={2013}>} Sales)=0,1,0)

Let me know

[#3]

Hi Alessandro

Thanks for your fast answer.

Seems to work.

THANK YOU SO MUCH!