Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.
Adity,
so why dont go with Pie chart if possible
thats not the solutions. I want to have trend, not comparisson.
any solutions?