Set Analysis for Outstanding Monthly Trend

[#1]

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.

Please check attached file.

Thank you

[sujeetsingh]

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

[#3]

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.

[sujeetsingh]

Adity,

so why dont go with Pie chart if possible

[#5]

thats not the solutions. I want to have trend, not comparisson.

[#6]

any solutions?