2 Replies Latest reply: Sep 25, 2017 4:39 PM by Jennifer Lyngle RSS

    Hello, I am looking to create table showing only the top 20 values of dimension

    Jennifer Lyngle

      In my dimensions, I have sub groups by MT, NM, NV, then by Region T1, T2 , T3……T40

       

      I want to create a table of totals grouped by

      if Sub Group = NM then ‘NM Total’

      then by the Top 20 Regions with all other listed as ‘Other Regions’ I have attached a spreadsheet for help.  Any suggestions are welcome.  Thank you!