Filter for report

[CommunityMember113484]

Hi,

I have a module with a list of products with different ages. I want an end user to be able to select whether from a list to show all products < 3 years, >= 3 years and >= 5 years.

In my module, I have created booleans to check for each of the above.

I have also created a list for the 3 periods. I'm a bit stuck now - can someone please assist?

Thanks

[rob_marshall]

@CommunityMember113484

Do you have a list with those values? That would be the easiest way of accomplishing this and then you can use the Tiering system found here:https://community.anaplan.com/t5/On-Demand-Courses/Working-with-Ranges-Tiers-or-Bands/ta-p/63734

Rob

[CommunityMember113484]

Thanks - just watched that module but I still can't figure it out!
我的布尔值< 3 > = 3年,> = 5years.
I also have created a list with the above, but how do I link them?

[rob_marshall]

@CommunityMember113484

Create a module with Products as well as Tenure (the new list), making sure you have a top member or Tenure. Do the tiering as defined in the above video where you have line items: min, max, both (I can't remember exactly the line items used in the video). Now you can filter on the line item Both.

Rob