8 Replies Latest reply on Aug 4, 2016 1:06 PM by Alexander Mou

    Is it possible to do indirect filtering with two dimensions?

    Stephen Jay

      I'm going to give a simplified example to a more complex workbook that I'm working on.

      Let's say I have a datasource with a table that includes two columns: State and Name.

      I created a parameter that allows you to select Name.

      If I select a name that is associated with a state (e.g. Florida), I want all states that are NOT florida to be filtered out of the view.

      This would be easy if there were some lookup function that acted like: function(Name)=State. I could then put this in a calculated value and use it in the filter.

       

      Has anyone successfully tried something like this?

       

      Thanks