Hi Friends,
I'm facing a problem with one of my graph while calculation running total for the report which displays past 12 months data.
Here is how i applied :
I have a measure value and a date column (month end date).
My Graph X axis will display month end date (starts from Dec'12 till Nov'13.) and measure for respective month value displays in Y axis.
The measure value onlu for last 3 months (Sep, Oct and Nov'13).
For ex: one record for sep, 3 record for Oct & 1 record for December.
I'm applying running-total(measure) in the data item.
When i run the tabular data the record displays as Sep - 1, Oct - 4 & Nov - 5. Which is correct.
Where as when i run the report, the graph displays as Sep - 5, Oct - 4 and Nov - 1 (which is wrong).
can any one correct where i went wrong?