Greetings, all. I have a list of things in an RG that record entries when people purchased a specific product. While each thing is unique, the product purchased may repeat for a certain customer. I need to create a list of things that show the most entry for each product to remove older duplicates.
As you can see, Item #1 is showing twice because a customer purchased access multiple times. Here is a sample of the data behind the scenes:
In this example, I’d want to group all Item #1 and Item #2 entries together and simply show the top entry (most recent).
Any ideas? I thought
:grouping, but that obviously complicates actions like filters.