Outstanding issue?

[Anonymous]

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

[JonnyPoole]

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

[Anonymous]

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

[JonnyPoole]

I'm not sure i would need to work with an example. sorry.