7 Replies Latest reply: Jan 23, 2018 6:54 PM by Andy Cosgrove RSS

    limiting and ranking data on a simple table based on a dimension and a measure

    Andy Cosgrove

      I have a table with 400 rows of data with the "DCIPU" column showing different values and the "MFG" column repeating the same names listed below based on the occurrence of the dimension

       

      I want to create 2 tables:

      1- limit the table to vview the 10 highest values for the DCIPU regardless of the MFG dimension

      2 - Show the top 10 performing values of DCIPU for each of the different MFG dimensions

       

      MFG

      DCIPU
      WMS1100
      Bally2100
      IGT1100
      Aristocrat1200
      EGT80
      Ainsworth5

       

      I tried to use the Top 10 dimension function and sorting by DCIPU but it returned the DCIPU values from highest to lowest value and all 400 rows of data instead of limiting it to 10

      I look forward to your answers.