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!
I've got the booleans for , >= 3 years and >= 5 years.
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