16 Replies Latest reply: Jun 2, 2018 10:16 PM by Alberto Morales RSS

    How can I filter a dimension within a "filter pane" by using an expression

    Alberto Morales

      Hello

      I have the dimension "Department" with a list of 5 departments (Finance, HR, Operations...) I know that I can manually click and select one department and filter it, but I would like to edit the Filter Pane and create an expression in order to show only one department so that every time I open the report the information is already filtered

       

      I have tried to do set analysis using the same logic as we use for measures "+sum({1<Department = {HR}>}" but i cannot get it

      Could you be so kind to help me?

      Thanks in advance

      A