Limit on selections

Is there a limit to columns or rows I can use in selections? How many can I select and hide at the same time?

Tagged:

Best Answer

  • Yes there is a limit.
    There is a limit on selections of 200 items per axis (this could be 200 items being shown, or 200 items being hidden). This number may vary if you are doing the selection on a nested axis.When working with a large number of items in selections, it may be necessary to do the selection the opposite way around to avoid hitting the limit, e.g. the dimension has 300 items and you want to show 250 of them; if you selected the 250 and clicked show you would hit the limit, but if you selected the 50 you didn't want and clicked hide you could get the selection you want.