Help with Dimension Limits!

[#1]

Hi all,

I'm having an issue with dimension limits. I have a straight table with a list of users and their corresponding database access information. I want the user to have the option to dynamically limit the number of users shown in the table, but (I think) due to multiple dimensions, I'm unable to properly limit the data. I've attached a sample for reference.

Thanks,

Paul

[#2]

Paul,

Are you trying to put dimension limit of employee name? If yes, try this:

[#3]

Yes, I want to limit the employees displayed. I opened your solution and it looks like below on my computer. It still shows "Others" repeated multiple times, which is undesirable. If I have "Display # Users" set to 3, I only want to show the top 3 lines.

[maxgro]

if you have multiple dimension you can

- uncheck show others

- or check and collapse inner dimension (see image)

explanation from online help

Show Others

Enabling this option will produce an Others segment in the chart. All dimension values that do not meet the comparison criteria for the display restrictions will be grouped into the Others segment. If there are dimensions after the selected dimension, Collapse Inner Dimensions will control whether individual values for the subsequent / inner dimensions display on the chart.

[#5 · Accepted solution]

unckeck 'Show others' under Dimension limits-Options.

[#6]

Hey Paul,

Maybe like attached.

It will limit the rows based on the UserID. if you enter 5 it will show users with ID 1-5. If entered 8 1-8 and so on.

Thanks

AJ

[#7]

Great, this helps. So it's not possible the show "Others" if I do it like this? It would be nice for the user to understand that there are additional items that are part of the table, but they are not shown for now.