2 Replies Latest reply on Aug 6, 2018 11:47 AM by Gerardo Varela

    Using action filter to select default filter choices

    james.evans.10

      Hi all,

       

      I have a situation in which my end user would like filters to automatically default to selections in other filters based on the first choice. I believe this is achievable through action filters but I cannot for the life of me figure out how to get it to work. I have attached an example workbook using the My Superstore data source. Essentially I put two filters on the dashboard, Market and Category. Ideally I would like the Category selection to change based on the Market selection. I tried creating an action filer with the code:

       

      CASE [Market]

      WHEN "APAC" THEN "Furniture"

      WHEN "EMEA" THEN "Office Supplies"

      WHEN "LATAM" THEN "Technology"

      WHEN "USCA" THEN "ALL"

      END

       

      Essentially I would like to make it so that when I choose APAC the category filter automatically defaults to Furniture, and so on..

       

      Can anyone help me out with this? Thank you always