Hi I have a stacked - trelli bar chart. dimension1 is for trelli, dimension2 for the different bars and dimension 3 for the stacking and coloring.
Dimension2 (lets say state) needs to contain only 2 values which are - a fixed state (let's take Texas) and all the selected states labelled 'Others'. If there's no selection on states then only Texas state will be shown while if there is a selection, Texas will be compared to all selected states combined.
I have made this chart but I am struggling with set analysis on dimensions that is, the part where Texas gets compared with selection is not working. Is it possible? Here's the calculated dimension I have and I know why it's wrong but please help me improve it.