Hi,
Please see attached XL. I want to be able to dynamically identify the top 5 Productids based on SoldDate descending and subsequently perform aggregations to these identified Productids.
Something like IF(AGGR(COUNT(Productid),Firm) >=5,Do(Something) on these selected Productids that are ordered by sold date desc
Requirement:
Identify All firms with 5 or more Productids
Order these product ids by descending solddate
If the user selects a city, then, the sorted productids should adjust with the selected city.
For example, if the user selects London, then the top 5 productids should be Productids 6 to 10.
Any help will be greatly appreciated.
Thanks