Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have year as dimension and measure as sales. For example, I have years 2011,2012,2013,2014. So if I select 2014, it should all last years also; when I select 2013, it should show 2013/12/11. Also if there are total 10 years in the data, I want to keep it limited upto last five years including the selected year.
Please advise.
BR,
SAK
try this
=Sum({<Year={">=$(=Max(Year)-4)<=$(=Max(Year))"}>}Sales)
Also, I dont want to get it affected by the selection in months and quarters list boxes. Please advise.
Thanks!
Hi,
Nullify your Month Field in above expression
like
Try this
=Sum({<Year={">=$(=Max(Year)-4)<=$(=Max(Year))"},Month=>}Sales)
Or
=Sum({<Year={">=$(=Max(Year)-4)<=$(=Max(Year))"},Month={*}>}Sales)
Regards,
in set analysis using "FieldName=", will ignore the selections in that field
=Sum({<Year={">=$(=Max(Year)-4)<=$(=Max(Year))"}, Month=, Quarter=, Day=, Week=>}Sales)
Hope it helps