If you are unable to create a new account, please email support@bspsoftware.com

 

Clustered and Stacked Columns chart with two Measures and two Dimensions

Started by Oussama, 08 Jun 2017 08:32:37 AM

Previous topic - Next topic

Oussama

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