Filter for report
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?
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
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?0
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.