I'm using the following expressions to determine what name should be shown based on date range selected. This gets me what I want to see, but when I click on a value that is being determined by the calculated dimension, it's filtering on all the fields in the calculated dimension. I only want to filter on the actual name I see. Anyone can help with this or offer a different solution.
If ([MaxDate] >= UltBrokerIncDate,UltimateBrokerName,ToBrokerName)
An alternative solution is to create two almost identical charts with the different dimensions, one with UltimateBrokerName, another with ToBrokerName. Show one chart or another depending on the UltBrokerIncDate condition.
No calculated dimensions, so the selection will work on click.
