4 Replies Latest reply on Jun 28, 2018 9:56 AM by Jim Dehner

    Selecting top 5 customers per each month

    Casey Gallaher

      Hello all,

       

      I am trying to make a report that shows the top 5 customers per each month based on sales. I seem to be having some difficulty trying to filter this. I selected the filter based on top n sum sales on the customer name dimension but it is not giving me the correct values. I was wondering if anyone has a work around with this.

      Screenshot 2018-06-28 11.22.27.png

       

      This is my worksheet I have no with just using the customers top n option as a filter.

       

      Thanks,

      Casey