3 Replies Latest reply on Nov 15, 2016 4:35 AM by Kajal Chandani

    Filter chart by rank based on latest month

    Bastien Clement

      Hello everyone,

       

      I have around 22 websites, and I want to display on a chart the number of visits by months for the last 2 years. I have the month in columns, sum of visits in rows and the website on the marks shelf in colors.

       

      I would like to display only the websites that were in the top 5 for the previous month. Is there any formula I could use?

       

      Thanks and Regards,

      Bastien