How do I change a chart's value based on their selction of a value in a filter?

[john_henry]

For example, I have a filter called RTM and it has the following values:  Indirect; Direct.

I also have a bar chart with Column A (as dimension) and sum revenue (as measure).  However, I want to change the bar chart based on the RTM selection.  For example, if they chose "Indirect" from RTM filter, then bar chart would use Column A and sum revenue for Column A.  However, if they chose "Direct" from RTM filter, then bar chart should use Column B and sum revenue for Column B only.

Make sense?

[Anonymous]

sum ( { <RTM={"Direct"} >}revenue)

or

sum ( { <RTM={"Direct"} >}ColumnA)

[john_henry]

That looks like it works for the measure, but I also need the x-axis categories to change based on the RTM selected.  .

Here's a simple example:

RTM	Column A	Column B	Revenue
Indirect	Company A	Company W	10
Direct	Company B	Company X	20
Indirect	Company C	Company Y	30
Direct	Company D	Company Z	40

If someone chose RTM=Indirect, then the x-axis would show Company A and Company C and y-axis would show revenue of 10 and 30 respectively.

If someone chose RTM=Direct, then the x-axis would show Company X and Company Z and y-axis would show revenue of 20 and 40 respectively.