We can control the number of categories of a dimension in a straight table using “Dimension limit” functionality. Look at the below options, here we have options to restrict values like:-
- Show only n values, it can be first, largest,smallest based on first expression
- Show values, those are greater than or equals to an exact amount or relative to other values.
- Show only those values which accumulates to a certain percentage or an exact amount
Here, your requirement is related with first option with facility to change the value of n dynamically. To perform this follow the below steps:
Create a variable, go to Setting (menu) --> Variable Overview --> Click on ADD to create a new variable. I have created a variable “vSunil”
Create a input box ( New Sheet Object --> Input Box) and select the variable name in “General Tab”.
Create Straight table with required dimension and expression and go to “Dimension limits” tab and select “Restrict which values are displayed using first option” and select first available option “Show Only”.
Select Largest and in second box write expression as “=vSunil+1”. Here I have add +1 to group rest of the categories in Others.
Now you can play with number of observation to show at front end.
Hope this helps!