4 Replies Latest reply on Apr 16, 2018 10:03 AM by Quinn Dippel

    Top N, Respective Month

    Quinn Dippel

      Hi All,

       

      I am trying to find a way to filter based on dates in a view. For instance, with Superstore data, I want to see SUM(Sales) for January 2017, February 2017, and March 2017 based on the top 20 customers in each respective month. When I use context filter, it is just using the top 20 in that whole time period, but I want the top 20 for each distinct month in the same view. I am attaching a workbook for how I want it to look in the visualization. Any help would be great.

       

      Thanks,

       

      Quinn