Set analysis ignore current dimension value

[Anonymous]

How can I ignore dimension values of 201801 to 201806 and show the average sales for 201401 to 201712 and from 201807 show the corresponding months average sales

Dimension	Expression
if(Vintage>=201801,Vintage)
201801	= Avg({Vintage={'>201401<=201712'}}sales)
201802	= Avg({Vintage={'>201401<=201712'}}sales)
201803	= Avg({Vintage={'>201401<=201712'}}sales)
201804	= Avg({Vintage={'>201401<=201712'}}sales)
201805	= Avg({Vintage={'>201401<=201712'}}sales)
201806	= Avg({Vintage={'>201401<=201712'}}sales)
201807	= Avg({Vintage={'=201807'}sales)
201808	= Avg({Vintage={'=201808'}sales)
201809	= Avg({Vintage={'=201809'}sales)
201810	= Avg({Vintage={'=201810'}sales)
201811	= Avg({Vintage={'=201811'}sales)
201812	= Avg({Vintage={'=201812'}sales)
201901	= Avg({Vintage={'=201901'}sales)
201902	= Avg({Vintage={'=201902'}sales)
201903	= Avg({Vintage={'=201903'}sales)
201904	= Avg({Vintage={'=201904'}sales)
201905	= Avg({Vintage={'=201905'}sales)
201906	= Avg({Vintage={'=201906'}sales)
201907	= Avg({Vintage={'=201907'}sales)
201908	= Avg({Vintage={'=201908'}sales)
201909	= Avg({Vintage={'=201909'}sales)

[sunny_talwar]

Should be something like this

If(Vintage >= 201806,
  Sum(Measure),
  Avg({<SetAnalysisRange>} TOTAL Aggr(Sum(Measure), Vintage))
)

[Brett_Bleess]

Siva, did Sunny's post get things working for you?  If so, please be sure to return to the thread and use the Accept as Solution button on his post to give him credit for the help and let others know it worked.  If you are still working on things, leave an update.

Regards,
Brett