Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts ,
I am trying to do this Aggr :
=Max(Aggr(Sum({$<Year ={">=$(=(max(Year ))-$(V_YearBack)) <=$(=(max(Year) ))"}>} Sales_EUR),Week_Extract))/1000
But this ... doesn't work !!
Any help is welcome
Thanks
Try something like this
=Max(Aggr(Sum({$<Year ={">=$(=(max(Year ))-V_YearBack) <=$(=(max(Year) ))"}>} Sales_EUR),Week_Extract))/1000