Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need help solving a situation. Let's suppose I have a table with up to 3 records for each salesperson. The date will have a Sales Date, Sales Person, and Sales Amount. I need a formula to calculate the average sales using only the most recent sale for each Sales Person.
Any ideas?
Thanks in advance.
Todd
Okay, I think I figured it out but Thought I would share my solution as it will hopefully save someone time in the future.
I used a combination of the AGGR function and the FirstSortedValue function.
=Avg(Aggr(FirstSortedValue([Sales Amount],-SaleDate),[Sales Person]))
Okay, I think I figured it out but Thought I would share my solution as it will hopefully save someone time in the future.
I used a combination of the AGGR function and the FirstSortedValue function.
=Avg(Aggr(FirstSortedValue([Sales Amount],-SaleDate),[Sales Person]))
Thanks Todd, can you please share a screenshot of that table where you have that calculation? I struggle with those,
Cheers,
Luis