Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I wanted to show the selected date outstanding amount to last 12 months .
suppose i have the outstanding amount in jan = 200 and mar = 300
so outstanding amount as on April month is 500.and i made payment in may = 500,
so may month outstanding is 0,and outstanding of june = 400 and july =300 then in chart it has to display like this
outstanding of as on apr = 500 as on may =0 as on june = 400 and as on july =700 it has to sum with previous month.
please give me ideas its urgent requirement.
Thanks,
krishna
You can use the accumulation function to aggregate prior records (months), or use the above() or before() functions with a rangesum() to have more control over how many previous rows you accumulate for the current row.
precise answer would depend on your data structure. a QVW will supply more a definitive solution
i did that thing but its showing in chart jan =200 ,mar= 300,apr=0 ,may =0 ,jun = 400 and july = 300 but i need to show the as on apr =500,may =0,jun = 400 and july =700
I'm not sure i would need to work with an example. sorry.