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

[Anonymous]

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!

[Anonymous]

Hi Jennifer,

If I am understanding correctly, I believe you should be able to set a data limitation on your Regions dimension. To do this,

expand the drop-down menu on your Regions dimension > under "Limitations" select Fixed Number > choose "Top" > and in the formula bar put "21" (as this will display the top 20 plus a section for "others").

A simple option to display values for only sub group "NM" would be to use the measure:

     sum({<sub_group={'NM'}>}VALUE)

Please let me know if this helps!

Thanks,

Austin

[Anonymous]

Thank you.  I had to change to a Straight table and create a couple of additional expressions, but I think this will work.

I appreciate the quick response!

Jennifer