11 Replies Latest reply on Oct 26, 2018 12:48 PM by Ombir Rathee

    Creating a Top-N set from the Total of rows in a table

    Marie Harris

      Hi there,

       

      I'm trying to create a Top-20 set based on the highest measure values on the Table total column. I've tried to do this by going to the Dimension that represents the rows in the table 'Create/Set' and 'Top' by the appropriate fields but I can't see anything that would represent the row total in there - do I need to create a formula?

       

      Unfortunately the workbook contains sensitive data so I can't upload it.

       

      Thanks

       

      Marie