I have a pivot table with filters. The user is supposed to limit their choices to a "reasonable" number however i expect they may not and if that happens there will be too much data for the pivot table.
Is there a way to remove the ability to "select all".
Is there a way to limit the number of choices in "select multiple" in a filter to assure the user is directed accordingly?
Thanks for any help i can get!