Background: Idea is to filter data based on the selection of the 'Brand Name' parameter.
Criteria:
- If selected 'Apple', then 'Category' should be only 'Indoor' and 'Industrial'.
- For 'MI' and 'Samsung', it should be 'Kitchen' & 'Accessories'
Initial thoughts: My idea is to have 'Brand Name' as a Parameter and the above criteria should reflect. But I am stuck as I am not able to filter the data as per the criteria within the Parameter scope at the 'Category' level and accordingly the corresponding 'Price' should show up. The filters are going to be Radio buttons in the Tableau dashboard.
There is a sample data attached having data in the 'Data' sheet.
Thanks in advance!
Create a Parameter and the use the below calculation in filter and select "True"
If [Brand Name] = [Brand Parameter] then
CASE [Brand Parameter]
when 'Apple' then ([Category] = 'Indoor' or [Category] = 'Industrial')
when 'MI' then ([Category] = 'Kitchen' or [Category] = 'Accessories')
WHEN 'Samsung' then TRUE
ELSE
FALSE
END
ELSE
FALSE
END
