set anlysiswith dimension

[souadouert]

Hello,

I need to use the set analysis with one dimension,

if (total in 2017> total in2018, yes, no)

[sunny_talwar]

What is the dimension and what is the expression?

[souadouert]

I have many clients and i need to calcult total sales for each client and i need to add a flag {yes , no}

if( total sales in 2018 < total sales in 2017, yes ,no)

[sunny_talwar]

In the script or in the chart?

[souadouert]

dimesion in chart

[sunny_talwar]

So, you have client as one dimension and you want to add the second one as yes or no?

[souadouert]

yes sunny

[sunny_talwar]

May be like this

Aggr(If(Sum({<Year = {2018}>}Sales) < Sum({<Year = {2017}>}Sales), 'Yes', 'No'), Client)

[souadouert]

and if I have the total prepared in the script ?

[sunny_talwar]

Then this

Aggr(If(2018Sales < 2017Sales, 'Yes', 'No'), Client)