Beast mode that would put people in a specific group based upon a date
I have a dataset that shows tenants that are late on their payments. Some our in Auction status, and it has an auction date. What I am trying to do is put these people that are in Auction status in to 3 groups. Those that are 30, 60 , and 90 days past that auction date.
Then Ideally, would be to use this in a pivot table where you can see those in each group you would click in to.