Skip to Content
0

Combining Data columns and filtering

Dec 30, 2016 at 08:21 PM

17

avatar image

==============================

I have a BEX Query that has 11 columns.

Column 1 is Transaction number

Columns 2-11 are Opp Reason 1, Opp Reason 2, Opp Reason 3, etc.

---Basically, there are transaction numbers and UP TO 10 reasons why the transaction was won or lost.

===============================

I have another query with the same transaction numbers that have information such as account, etc.

===============================

I have merged the dimension for Transaction number. Now I would like to build a bar chart that has each reason listed and a count of how many times that reason appears in the data.

I would also like a table that has the account, etc. information listed. I would like to create element linking so when a user clicks on Reason "X" then the table below will filter down to the lines that have that as a reason.

===============================

An example would be

Transaction 1 was won because of reasons A, B, C, X, Y

Transaction 2 was won because of reasons B, C, X, Z

When you click in the bar chart for Reason A, Transaction 1 is filtered in the table below and the column listing the reasons shows reason A

When you click in the bar chart for Reason B, Transactions 1 & 2 are filtered in the table below and the column listing the reasons shows Reason B.

I hope that is clear enough, this one has stumped me!

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

0 Answers