How do you make a filter out of three separate columns? Hello, I'm new to Tableau and would appreciate any assistance or direction along the way.
I'm now working on a problem where I need to create a filter that considers three columns, and then the chart should display the data based on the interactive filter option. This is an example of a table structure.
Region | Sales_upper | Sales_lower | Sales_avg
A. | 120. | 60 | 100
B. | 150. | 50 | 100
This is my goal: I want to be able to view my sales data by area and have a filter named 'SALES' as a radio button that allows me to select between 'Sales lower', 'Sales upper', or 'Sales avg'. If I choose 'Sales upper,' the data should only be filtered for the first two columns, Region[A,B], and Sales upper[120;150].
How would I put my plan into action?