If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Problem : Running Total in Graph

Started by Sakthi, 12 Dec 2013 10:29:41 AM

Previous topic - Next topic

Sakthi

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?