==============================
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!