Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I need to use the set analysis with one dimension,
if (total in 2017> total in2018, yes, no)
Or use Only()
Aggr(If(Only({<Year = {2018}>}Sales) < Only({<Year = {2017}>}Sales), 'Yes', 'No'), Client)
What is the dimension and what is the expression?
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)
In the script or in the chart?
dimesion in chart
So, you have client as one dimension and you want to add the second one as yes or no?
yes sunny
May be like this
Aggr(If(Sum({<Year = {2018}>}Sales) < Sum({<Year = {2017}>}Sales), 'Yes', 'No'), Client)
and if I have the total prepared in the script ?
Then this
Aggr(If(2018Sales < 2017Sales, 'Yes', 'No'), Client)