COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: Oussama on 08 Jun 2017 08:32:37 AM

Title: Clustered and Stacked Columns chart with two Measures and two Dimensions
Post by: Oussama on 08 Jun 2017 08:32:37 AM
Hi Folks,

The following data set contains Gross Revenue and Qty by Category and Year:

Year;Category;Gross Revenue;Qty
2015;A;1000;500
2015;B;1500;1200
2015;C;1200;900
2016;A;2000;1000
2016;B;1300;1040
2016;C;800;600
2017;A;500;250
2017;B;700;560
2017;C;1000;750

I want to show the Gross Revenue and the Qty clustered by year and stacked by Category... you can refer to the attachment below

Please share your thoughts...

Thanks
Ouss