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)
What do I do with this?
so in this case i need this ?
Aggr(If(({<YEAR={'2018'}>}Sales)< ({<YEAR={'2017'}>}Sales), 'Yes', 'No'), Client)
You might have missed the Sum()
Aggr(If(Sum({<Year = {2018}>}Sales) < Sum({<Year = {2017}>}Sales), 'Yes', 'No'), Client)
Or use Only()
Aggr(If(Only({<Year = {2018}>}Sales) < Only({<Year = {2017}>}Sales), 'Yes', 'No'), Client)
THANK YOU SUNNY