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
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.
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