1 of 1 people found this helpful
Try this. Within your worksheet, to have a quick filter, you need to have the dimension on the filters shelf. Within the filters shelf, click on the field, hit the down arrow, click sort, and then do it manually.
I believe if you set the "default sort" in the Data Window (where your dimensions/measures/sets, etc.) are listed before using it in the view, they will take on the default sort you set. That's a right click option in the data window on a dimension. However, that will obviously sort the dimension in that order whenever its used in a view as well, and I'm not sure thats what you want--Jeff's solution should only apply to that filter, I believe, so that may be the best route for you.
Another option is to create a parameter from the field's values, and list them out in whatever order you want--but that has all the limitations of parameters (single select, static, etc.) Cheers!
Thanks Jeff. Interestingly, sorting the dimension manually in the filters section had no effect on the quick-filter sort. Even after deleting the quick filter and adding the dimension over again, sorting in the filters section, and then creating the quick filter, it didn't work. It should have gosh darn it!
Thanks Matthew! It worked to modify the default sorting manually in the dimensions area. You saved me a lot of time trying to figure this out or worse yet modifying the original data with numbers.
I faced the same issue some time back
Yes we do have solution for this
1)Go to Sheet
2)Select the attribute (dimension ,measure.. ) ->right click->default properties->Sort
3)Select Sort by ->Manual
4)select and use up and down button at right hand
You are all set