4 Replies Latest reply on Jul 10, 2018 6:55 AM by Vincent Baumel

    Need help determining max(date) with multiple dimensions and filters

    Vincent Baumel

      Hi friends-

       

      Here's something along the lines of what I'm working with and the closest I've come to a solution:

       

       

      This calculation works fine as long as I account for every field and filter in the worksheet. I've got additional filters though, and I'm not sure how to account for them. Ultimately, I want to return the most recent sum of sales for each line. It's the end of the day and the solution is probably just *barely* out of reach for me, but if anyone has any ideas please let me know!

       

      Thanks,

       

      Vince