Year dimension should show all last years

[#1]

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

[CELAMBARASAN · Accepted solution]

try this

=Sum({<Year={">=$(=Max(Year)-4)<=$(=Max(Year))"}>}Sales)

[#3]

Also, I dont want to get it affected by the selection in months and quarters list boxes. Please advise.

Thanks!

[PrashantSangle]

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,

[CELAMBARASAN]

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