set anlysiswith dimension

[souadouert]

Hello,

I need to use the set analysis with one dimension,

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

[souadouert]

[sunny_talwar]

What do I do with this?

[souadouert]

so in this case i need this ?

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

[sunny_talwar]

You might have missed the Sum()

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

[sunny_talwar · Accepted solution]

Or use Only()

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

[souadouert]

THANK YOU SUNNY