Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
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