New Filter - From Column not Dimension

acarrara
acarrara
in User Experience

I need to create a filter for one of the columns in my module.  It is not part of the dimension and it needs to be a drop down select list not the default filters in the module.

 

How do I accomplish this?

Tagged:

Answers

  • nathan_rudman
    nathan_rudman
    Hi,

    find the answer here:
    https://community.anaplan.com/t5/On-Demand-Courses/User-Filters/ta-p/63725
  • ChrisAHeathcote
    ChrisAHeathcote

    @acarrara 

    Create a module that we will use to select the object to be filtered. This will be the same list that is used in the target module. 

    Create a new line item in the target module and format this as boolean. This will the line item that we will eventual use inn our filter.

    Use the following formula; =Target.Filter = FilterSelection.ListItem 

    The boolean will register as TRUE when the line item in our selector equals the line item from the drop down in the target module.

    In the UX apply a filter in the grid settings using the filter line item in the target as your filter criteria. 

    Good luck, Chris 

Categories