Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Friends,
I need a help in finding cumulative value in a straight table for the attached QVW file.
I wanted to find the cumulative values based on ID.
Result should be like the below: (Based on the ID the cumulative values will be)(this sample is from Excel)
Regards,
Pooja
Hi try this ,
---- RangeSum(Above(Sum(your value),0,RowNo()))
Like attached???
Thanks,
AS
Try with for TOTAL
=RangeSum(above(total Sum(AMOUNT),0,RowNo(Total)))
And by groups, see attached file
hi
Please find attached.
HTH