topic Re: Most Recent Sales by Salesperson in QlikView https://community.qlik.com/t5/QlikView/Most-Recent-Sales-by-Salesperson/m-p/1410366#M513327 <HTML><HEAD></HEAD><BODY><P>Okay, I think I figured it out but Thought I would share my solution as it will hopefully save someone time in the future.</P><P>I used a combination of the AGGR function and the FirstSortedValue function.</P><P></P><P>=Avg(Aggr(FirstSortedValue([Sales Amount],-SaleDate),[Sales Person]))</P></BODY></HTML> Fri, 17 Nov 2017 04:14:04 GMT Anonymous 2017-11-17T04:14:04Z Most Recent Sales by Salesperson https://community.qlik.com/t5/QlikView/Most-Recent-Sales-by-Salesperson/m-p/1410365#M513326 <HTML><HEAD></HEAD><BODY><P>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. </P><P></P><P>Any ideas?</P><P>Thanks in advance.</P><P>Todd</P></BODY></HTML> Fri, 17 Nov 2017 04:02:03 GMT https://community.qlik.com/t5/QlikView/Most-Recent-Sales-by-Salesperson/m-p/1410365#M513326 Anonymous 2017-11-17T04:02:03Z Re: Most Recent Sales by Salesperson https://community.qlik.com/t5/QlikView/Most-Recent-Sales-by-Salesperson/m-p/1410366#M513327 <HTML><HEAD></HEAD><BODY><P>Okay, I think I figured it out but Thought I would share my solution as it will hopefully save someone time in the future.</P><P>I used a combination of the AGGR function and the FirstSortedValue function.</P><P></P><P>=Avg(Aggr(FirstSortedValue([Sales Amount],-SaleDate),[Sales Person]))</P></BODY></HTML> Fri, 17 Nov 2017 04:14:04 GMT https://community.qlik.com/t5/QlikView/Most-Recent-Sales-by-Salesperson/m-p/1410366#M513327 Anonymous 2017-11-17T04:14:04Z Re: Most Recent Sales by Salesperson https://community.qlik.com/t5/QlikView/Most-Recent-Sales-by-Salesperson/m-p/1410367#M513328 <HTML><HEAD></HEAD><BODY><P>Thanks Todd, can you please share a screenshot of that table where you have that calculation? I struggle with those,</P><P></P><P>Cheers,</P><P></P><P>Luis</P></BODY></HTML> Fri, 17 Nov 2017 04:31:52 GMT https://community.qlik.com/t5/QlikView/Most-Recent-Sales-by-Salesperson/m-p/1410367#M513328 luismadriz 2017-11-17T04:31:52Z