Issue with Y/Y in chart

[#1]

Hi,

Currently my chart looks like below because 2016 has data for all the 53 weeks but 2017 only has data for 10 weeks. So I want to get rid of weeks greater than 10 in 2016.

My dimension is Week Of year

And my measures are:

Max Year = sum({<Year={'$(=Max(Year))'}>}Amt)

Max year -1 = sum({<Year={'$(=Max(Year)-1)'} , DATE={'<=$(=AddYears(max(DATE), -1))'} >}Amt)

Am I missing something?

[vishsaggi]

Can you share a sample app to work on. ?May be try like: I am not sure have not tried

Max year -1 = sum({<Year={'$(=Max(Year)-1)'} , DATE={'<=$(=AddYears(max(DATE), -1))',

                 [Week of Year] = {'$(= [Week Of Year] < 11)'} } >}Amt)

[Anil_Babu_Samineni]

As provide seems ok to me. But, You are talking about Week might you missed Week on your query