Filter Line Item in Module view based on another Line Item

Hello,

Is there a way to filter line items in a module on a dashboard based on another line item? I have a line item called input preference, which has two options: Dollars or Percent. If dollars is selected, I don’t want my end users to see the percent input line item, and vice versa. When I try to use the filter, and select line items, it only allows me to filter based on the other dimensions in the module.

Accepted answers

DavidSmith

Yes it is, but it's little fiddly to set up, but I'll go through it bit by bit. In the example below I have a module called Data LISS whihc contains two line items, Dollar and Percent

1. Set up a line item subset based on the Data LISS module and include the two line items you would like to filter

2. Create a list (in this case I've called it Dollar:PCT) and enter the two values Dollar and Percent

3. Create an input module for the preference (I think you already have this) and format the line item as the list created in 2.

4. Create a module to turn the input preference into a boolean (dimensioned by the list from 2. and formatted as boolean, the formula in my example is Choice Input.Input Prefence = ITEM('Dollar:PCT')

5. Create another module (LISS Filter) dimensioned by the LISS created in 1. with two line items, 1 formatted as the list created in 2. and the other as a boolean. Map the two lines as shown and then add the formula 'Dollar:PCT Filter'.Filter[LOOKUP: Choice] to pull in the boolean from 4.

6. Now the filter module is set up ready to use in the data module.

Good luck!

David

All comments

DavidSmith

Yes it is, but it's little fiddly to set up, but I'll go through it bit by bit. In the example below I have a module called Data LISS whihc contains two line items, Dollar and Percent

1. Set up a line item subset based on the Data LISS module and include the two line items you would like to filter

2. Create a list (in this case I've called it Dollar:PCT) and enter the two values Dollar and Percent

3. Create an input module for the preference (I think you already have this) and format the line item as the list created in 2.

4. Create a module to turn the input preference into a boolean (dimensioned by the list from 2. and formatted as boolean, the formula in my example is Choice Input.Input Prefence = ITEM('Dollar:PCT')

6. Now the filter module is set up ready to use in the data module.

Good luck!

David

KristinaZh

Thanks, very useful proposal.

Is there any workoaround for it to work on non-number LIs?

I need also boolean and List formatted Items to be shown hidden/based on user preference, however I can't add these in the List Subset to make it work.

DavidSmith

A known limitation of line item subsets is that you can only use them for numeric items. I'm not sure of a workaround for Booleans and other formats, but I will have a think

Sorry I can't be of more help at this time

David

Quick Links

🔥 Popular Content
🚀 My Activity
⭐️ Recent Discussions
🙋🏻‍♂️ Unanswered
👥 Groups
⚙️ About Community

Can you help?

Unanswered questions

Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385