8 Replies Latest reply on Oct 17, 2018 7:04 AM by meenu choudhary

    Need help with Top Sold Item for each Agent

    Aniket Pathak

      Hello,


      Currently I am working on a dashboard which tracks the performance of Sales agents.
      So for each agent I want to plot the total items sold, total sales and top selling item.
      Top sold item is on quantity, but if there are two item with same count then consider the item with highest revenue; if there is still a tie, then show all.

       

      I am trying to figure this out with LOD expression but not sure how this will work. Please advice.

       


      Thanks in advance.

       

       

       

      Regards,
      Aniket