Hi Team,
I have one expression below that expression is working in KPI Chart and not working in Table, Not working means when i have applied expression in table only one record is showing, i want to show the negative date dimension wise, like plant and item combo first negative value like that remaining
Please suggest ASAP
firstsortedvalue(REAL_DATE,
aggr(if(
($(vOnhand)) + aggr(rangesum(above((ProjInv_Actuals1),1,rowno())),REAL_DATE)<0,
REAL_DATE),
REAL_DATE))