Hi all,
I have a huge problem with Cognos 10.1 Report Studio. I'm trying to combine lines and bars into the same chart. Is this possible at all?
The idea is to show jan to dec (2012) actual, budget and forecast figures with lines (three different - of course). Then i'm trying to add two bars to the chart (to the category x-axis), 2013 and 2014 budget figures. This chart have two prompts where the end user can select following business areas and profit and loss accounts.
Can somebody help me with this problem?
\\Janne
It can be done but it's not easy.
I took the following steps :
1) I made a chart with the bars (1 query for this)
2) I made a chart with the lines (1 query for this)
3) I made a union query containing above mentioned queries and poured it into a list. Then i made sure the data in that list made perfect sense, it sounds obvious but this is really the hardest part.
4) Made the chart containing the dataset and played around with the Aggregation and Rollup properties.