I need to build a beast mode that gives me the days since the last time a sales rep transacted. My dataset includes several transactions by the same rep but I only want one line per sales rep and however many days it has been since their most recent sale. Does anyone have experience with this?
--I've built a beast mode to give me the date difference for today vs. the date of sale. I just need it to ONLY return the most recent sale data rather than one line for each of the rep's sales.