I am trying to create two-level x axis chart in APEX. I want to achieve the same result in Apex as you can see in this excel example:
This is my table:
Source type is set to sql query in Apex:
For 2016 serie:
select PRODUCT ||' - '||CATEGORY , PRICE from TEST_PRODUCT where DATE_C = 2016 GROUP BY PRODUCT ||' - '||CATEGORY, PRICE;
For 2017 serie:
select PRODUCT ||' - '||CATEGORY , PRICE from TEST_PRODUCT where DATE_C = 2017 GROUP BY PRODUCT ||' - '||CATEGORY, PRICE;
This is generated chart in Apex:
I want to achieve the same result as in excel. Is it possible to create Two-Level x axis chart in Apex? I use oracle 12c with Apex 5.1.3 .