Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

APEX: Two-Level x Axis bar chart

boris123Oct 30 2017 — edited Feb 7 2018

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:

yeSXc.png

This is my table:

R4lE5.png

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:

WuKBJ.png

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 .     

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 7 2018
Added on Oct 30 2017
3 comments
2,155 views