Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I tried bellow query but its not working, find the image in the attachment
"rangesum( above( sum( {$<Month>} [Actual SPCD hit rate_CUTTING]),0,12) )"
Find the answer below
=avg({<Year={'$(vPriorYear)'} ,Month=,Day=,Date={'<=$(vYear)'}, MonthYear=>}[Actual GRN Hit Rate_STORES])
Find the answer below
=avg({<Year={'$(vPriorYear)'} ,Month=,Day=,Date={'<=$(vYear)'}, MonthYear=>}[Actual GRN Hit Rate_STORES])