Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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) |
Should be something like this
If(Vintage >= 201806,
Sum(Measure),
Avg({<SetAnalysisRange>} TOTAL Aggr(Sum(Measure), Vintage))
)
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