Functionality to hide rows with a criteria

Order Date	Item	Quantity	Shipping Status
Dec-3-2020	Arm Chair	50	Not Shipped
Dec-4-2020	Office Desk	30	Delivered
Dec-4-2020	HP Printer	20	Delivered
Dec-6-2020	Dell Laptops	3	In Transit
Dec-9-2020	Samsung TVs	4	Not Shipped
Jan-5-2021	Light bulbs	10	In Transit

This would be a checkbox. If checked, delivered items disappear from the grid. If unchecked, all items display on the grid.

Hide Delivered Items?

Hello, I'm trying to have a Boolean checkbox that allows me to hide the rows with Delivered status in the new UX. This will allow the business planner to focus on the rows with items that are yet to be shipped or in transit, but also still have the option of seeing all items by unchecking the "Hide Delivered items?" box)

Thanks in advance for your help.

Accepted answers

JaredDolich

@sosunkwo

Great question. You can solve this rather easily with a filter.

1. Create a line item in your transaction module that looks for the checkbox to hide delivered product.

2. Use that as a filter in a saved view

All comments

JaredDolich

@sosunkwo

Great question. You can solve this rather easily with a filter.

1. Create a line item in your transaction module that looks for the checkbox to hide delivered product.

2. Use that as a filter in a saved view

sosunkwo

Hi, @JaredDolich , I want to make sure I understand the steps here:

1. Create a Boolean formatted line item (i.e. Hide Delivered Items?)

2. In the transaction module, create a line item (I'm assuming this would be Boolean as well) to looks for the "Hide Delivered Items" checkbox. I assume this would have a formula such as IF Hide Delivered Items? THEN TRUE ELSE FALSE?

3. Add the filter (from step 2) to the saved view?

Is this what you mean?

MarkWarren

The line item you create will be a boolean, call it "Delivered?"

This has a formula like:
Shipping Status = SYS Shipping Status.Delivered

This is checking that the Shipping Status matches a known state (held in a system module).

The saved view can then be filtered on: NOT Delivered? AND Hide Delivered Items?

JaredDolich

@sosunkwo

You're almost there. @MarkWarren has it right. You need a line item that checks for delivery. If it's true then you can filter that out. Then create a saved view.

ChrisAHeathcote

A simpler approach which would not require any additional modelling is to simply filter it out from your UX view.

This will require that the line item is formatted as a list.

Select the required line item, navigate to the filter icon and select the 'is not equal to,' and select the 'Delivered' list item.

To remove the filter follow the same steps but this time deleting the filter criteria.

This will involve more steps but removes the need for additional modelling.

sosunkwo

Thank you all for the inputs. I've created the functionality and it works as expected. I also know about using the filter icon on the grid, but I've found that some users prefer to see a filtering option in plain sight, and that requires minimal effort from them 🙂

My Solution (just in case anyone stumbles on this question and needs to know my step-by-step solution):

- Created a Systems Module, called SYS Shipping Status Details with the Shipping Status list as a dimension.

This module has one line item called Shipping Status with a formula: ITEM(Shipping Status) to get the corresponding shipping status value

- Next I created a User Filters Module with the Users List as a dimension. In blueprint view, under the Users Lists column, I set Show All to Off.

This module has one Boolean-formatted line item called Hide Delivered Items?

Then, in the Transaction Module, I created two extra line items. The first line item Delivered? has a formula: Shipping Status = Shipping Status.Delivered. Returns true if the item has a delivered status, else false.

The second line item is Delivered Item Filter and has the formula: IF User Filters.Hide Delivered Items? THEN NOT Delivered? ELSE TRUE

In the same Transaction Module, I created a Saved View for the dashboard with a filter "Delivered Item Filter is equal to ✔ "

JaredDolich

@sosunkwo

Thank you for taking the time to document your solution! Greatly appreciated. Nice work!

Quick Links

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