5 Replies Latest reply on Jun 23, 2016 7:57 AM by Joe Oppelt

    Find Products which are only increasing

    Lazy Rambler

      Hi,

       

      I have a requirement to only find top products which increase over time. All the other accounts should be filtered out.

       

      Likewise, I have to find the bottom products which decrease every single period of time.

       

      Also, find products which have the biggest drop from initial date to the most recent date. And products which have the biggest gain from initial date to recent date.

       

       

      For example in this screenshot
      1. I only want furniture to remain in the view- that is the only account which is increasing every single time(There is no product which loses every single time, but you get the gist.

       

      2. In the same screenshot, the biggest gain is again furnitues. And the biggest drop is for Office suuplies .

       

      How to accomplish this? Thanks