Skip to Content
0

Xclesius Bar Chart with multiple Bex Querys

Apr 28, 2017 at 02:21 PM

18

avatar image
Former Member

Dear Experts,

I need to combine two bex querys in Xcelsius.

My Requirement.

I have two bex querys in my Xcelcius.

First Query Contains objects like KPA ID, KPA Name

second querys contains KPI ID,KPI Name,KPA ID,Sales,Profit.

I have a combobox(KPA Name)

KPA Name ( New york, California,Alabama)

If I Select New york in my combobox i need to display KPI Name in my Bar chart Y axis Lable and profit in X axis lable.

here tricky is in New york we can have multiple KPI Name which are not same as California and alabama.

Supose if ii select California in my combobox I need to Display Different KPI names In My Bar Chart Y axis Lable.

I don't want to create multiple bar charts in single chart i need to solve this requirement.

we have almost 20 to 30 records in KPI Name.

I hope my requirement is clear for you.

Please assist me to solve this issue.

Thanks.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers