I am currently using an OLAP cube connection and I want to sort my bar charts e.g. in a custom way - meaning: NOT alphabatically, highest to lowest and vice versa.
Still working with the cube connection, in excel I would just convert my pivot-table or whatever to formulas and then change the order of dimensions as I wish by a "drag-and-drop" approach (hope this makes sense).
Does anyone know a work-around to this issue? It is not possible to change the data connection atm., but it's something we are planning to do down the road.
Bar charts should allow you to change the sorting from lowest to highest or vice versa using the sort options under the ... button. Unless (???) they don't work for OLAP cubes? But for drag and drop - I agree, it would be nice to just sort things that way too sometimes.
Yep, sure does. Is it possible to smash the data set up with a simple excel worksheet that lists the companies and has a sort order column for them? If it does, you could then use the sort order column as the default sort for the company dimension?