COGNOiSe.com - The IBM Cognos Community

Hi,

I have a bar chart report with following requirement:

Month          Amount
Jan                 10
Feb                 2
Mar                 5
Apr                 15
...                  ...

In the bar chart, I have to display each Month of the year (Jan - Dec) in X-axis and show the Amount of each month in Y-axis.

However, every month amount in the chart have to include the amount of previous months (growthing graph).

Does anybody know how to make such kind of accumulation chart in Cognos ?


Thanks !

Hi,

Here there is an ambiguity in the question whether you need

1.   To include the amount of immediate previous month to current month? or
2.   To include all previous months to current month?

If your case is 1st one use Moving-Total function.
Syntax: Moving-Total ([Data Item],2)

For 2nd case Use Running-Total.

Tnx,
Sudhir.

Hi,

Create 12 Months Sale Amounts in different Query Items First, Then Cretae Acuumulated Sales Query Items. Use Acuumulated Sales Query Items in Chart. Drag those Columns in the X-Axis One beside one.
You will Get the Required result.

Please Go though the Attched Report Spec. It Is created using Go sales and Retailers Package.

Please get back to me is this Solution Meets your Requirement or not.

Thanks.

Thanks for yours solutions. It works fine.

However, the requirement have been updated to show the amount with each sales.

E.g. Total amount in Jan is 10, that included Sales A: 5, Sales B : 2 and Sales C : 3
      and then plot the stacked bar chart in 'Jan' cloumn

For every month, each column have to include all previous months amount of each Sales and plot the accmulated amount in the stached bar chart.

Proposed output chart is attached for yours reference !

Any suggestion of that ?

Thanks in advance !