2 Replies Latest reply on Sep 22, 2018 1:16 AM by chinmay tatwawadi

    Top and Bottom clients over custom calculation

    chinmay tatwawadi

      Hi,

       

      I am trying to narrow down on my top and bottom clients based on their Year over Year performance. The solutions available out there don't seem to be for custom calculations such YoY change. Here's an example:

       

       

      "Count" is basically YoY change. How do I now narrow down to, say, top and bottom 3 clients?

       

      I tried to use sets but didn't get the option to select the YoY change:

       

       

      Please find the attached notebook with dummy data

       

       

      Regards