Hi
I have a pivot table linked to a dynamic ODCB data source.
The pivot table (rows field) is sorted alphabetically by 'Brand', but ideally I would like "Other" to appear at the bottom.
I don't think I can use custom lists/sorting as the data is dynamic and multiple brand names can be added when refreshed etc.
Is there a way to sort "Other" at the bottom? Or can I somehow create a Custom list using wildcards and 'Other at the bottom??
Many thanks
Bookmarks