Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have created the Bar Chart with AGGR function with below expression.
Expression:
Sum(Aggr(Sum({<ShiftDate= {"<=$(=max(ShiftDate))"},FiscalMonth = p(FiscalMonth)>}[Net Available]),Cell,ShiftDate))
if I select ShiftDate = '07/07/2021', The date Should start from '28/06/2021' to '07/07/2021' and so on.
PFA...
Thanks in advance.
Regards,
Dinesh Kumar Mani.
Hi
Try like below
Sum({<ShiftDate= {"<=$(=max(ShiftDate))"},FiscalMonth = p(FiscalMonth)>}Aggr(Sum({<ShiftDate= {"<=$(=max(ShiftDate))"},FiscalMonth = p(FiscalMonth)>}[Net Available]),Cell,ShiftDate))
o/p:
Hi
Try like below
Sum({<ShiftDate= {"<=$(=max(ShiftDate))"},FiscalMonth = p(FiscalMonth)>}Aggr(Sum({<ShiftDate= {"<=$(=max(ShiftDate))"},FiscalMonth = p(FiscalMonth)>}[Net Available]),Cell,ShiftDate))
o/p: