Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Try this.
Sum({<Year={$(=max(Year)-1)},fiscal_quarter=, Month=, [Date]=, Month={'<=$(=max({<Year={$(=max(Year))}>}Month))>'}>}accessories_revenue)
Thanks