Waterfall charts in Cognos 10

[cbansal]

Hi,

I have my data as below:

Month   Revenue
Dec-11   120000
Jan-12   130000
Feb-12   140000
Mar-12   110000
Apr-12   100000
May-12   130000
Jun-12   114667
Jul-12   112667
Aug-12   110667
Sep-12   108667
Oct-12   106667
Nov-12   104667
Dec-12   102667
Jan-13   100667

I need to make a waterfall chart which will use Dec 11 as the starting point and then show the progressive increment/decrements. How do I do this in Cognos 10 Report Studio? I am a novice to this.

Help needed urgently.

Thanks

[MFGF]

Hi,

Create a new chart report and choose one of the "Progressive" chart types from the list. Set your Month values to be the Categories, and for your Default Measure, bring in a Query Calculation from the toolbox and set the expression to be running-difference([Your Revenue Item])

Cheers!

MF.

[cbansal]

Thanks.

Another level of complexity just got added by client.

To set the stage, the revenue given above is from a High level Department (Super Department, Lets say Electronics)
Now this revenue comprises of revenue from several small categories

So if my table now looks like:

Super Dept   Time                   Revenue   Categories   Revenue
Electronics   31-Dec-12   392000    TV                   130000
                                                  Laptop           120000
                                                  Desktop           12000
                                                  Camera           50000
                                                  Tablet           80000
                   31-Dec-13   455000    TV                   120000
                                                        Laptop           110000
                                                  Desktop           50000
                                                  Camera           25000
                                                  Tablet           150000

Now if I look at the change from 392000 to 455000, I can attribute the change to change in individual categories. So I want a typical waterfall chart where the first column represents the 392000, next set of columns gives me relative change in each category (fro TV: -10,000 and so on) and the final column should give me 455000. Is this possible in Cognos? How can I achieve this?

Thanks