Hey Mandar -
Unfortunately, there is no way to change the text in question. If you'd prefer not to show it altogether, you can turn it off via Customize | "Show 'All" Value".
If you really want to get this done, you might consider using a Parameter instead. For example, lets say there are only two combinations of zones:
South + North
East + West
You could create a parameter named "Zone Filter" to allow people to choose these values and then use a Calculated Field to leverage the result and act as a filter itself:
IF [Parameters].[Zone Filter] = "South + North" THEN
IF ([Zone] = "North" OR [Zone] = "South") THEN "ok" ELSE "no" END
ELSEIF [Parameters].[Zone Filter] = "East + West" THEN
IF ([Zone] = "East" OR [Zone] = "West") THEN "ok" ELSE "no" END
The expression above would return either "ok" or "no" for each row in your dataset based on it's "zone-ness" and what value was selected in the [Zone Filter] parameter - so you'd use calculated field as a filter itself, choosing "ok" as the value to see...
In all honesty, I probably wouldn't bother with this myself because I'd be introducing additional complexity and slowing things down ever-so-slightly with the complex-ish filter condition in an effort to make something visually pleasing. I'd rather have the raw speed
Thanks for your response on this.
Just a quick question. Is there any way we can remove "All" when there is only 1 value in the filter?
So say for a manager who is responsible for only one zone, he should not be able to see ALL.
Also is there any way I can default the value for each user?
Yes, I havde voted in favor of the original Idea.
Hi Mandar -
Sorry, nothing that fancy.