# Set Analysis for Outstanding Monthly Trend

Hi,

I have a calculations to calculate Outstanding value based on invoice and payment transactions from each month. With this calculations i can get an outstanding value just for selected Month. My problem is, i cant show it as Outstanding trend in chart, I want to show it as an outstanding monthly trend but what i get is a accumulations.

Thank you

• ###### Re: Set Analysis for Outstanding Monthly Trend

Please explain what you want in chart....

is it that you want the chart trend for selected month (day wise or week wise) or something else

• ###### Re: Set Analysis for Outstanding Monthly Trend

Yes..it is a chart trend for selected month with abbility to day also.

Example:

Outstanding for

2012 Okt = 100.000

2012 Sep = 120.000

2012 Aug = 90.000

2012 Jul = 80.000

Assume i have 2 charts

1. Gauge chart, to show outstanding value for selected month.

2. Line Chart, to show outstanding trend in month year

if i selected on Sep 2012, my chart will shown

Gauge chart: 120.000

Line Chart

2012 Sep : 120.000

2012 Aug : 90.000

2012 Jul : 80.000

current conditions, my line chart is not showing like above but showing the accumulation for outstanding 2012 Sep.