Privious Year YTD

[Anonymous]

Hi

I am struggling alot to show the Previous year YTD info in a table.

Below mentioned is my expression. Its showing the entire previous year data. But logically it has to show till August 2016.

Sum({<Year={$(vPriorYear)}, fiscal_quarter=, Month=, [Date]=, Datekey={">=$(=Num(YearStart(AddYears(Max(Datekey),-1)))) <=$(=Num(AddYears(Max(Datekey),-1)))"}>}accessories_revenue)

Can you please help me to fix this issue?

[yenumulagopi]

Try this.

Sum({<Year={$(=max(Year)-1)},fiscal_quarter=, Month=, [Date]=, Month={'<=$(=max({<Year={$(=max(Year))}>}Month))>'}>}accessories_revenue)

Thanks