1 Reply Latest reply on Mar 6, 2018 6:56 AM by Simon Runc

    Custom Sorting & Top N by Multiple Dimensions

    Moni Singh

      Hi I am trying to sort and filter for top 5. Below is how my Pivot table looks.

       

      What I trying to do is sort by Views (measure) and only keep top 5 postal code by device and content type.

       

      Screen Shot 2018-03-06 at 7.57.12 AM.png

       

      Essentially I am trying to get my table to look like this below.

       

      Screen Shot 2018-03-06 at 8.08.09 AM.png

      Attached is my workbook. Please refer to worksheet "Top 5 Videos Watched"