Force Order for Data in View
I have a grouping for some financial data that occurs across multiple reports.
I would like to be able to fix the order of the values in column (MA4) to be the following:
- Tuition Fees & Educational Contracts
- Funding Council Grants
- Research Grants & Contracts
- Other Income
- Endowment & Investment Income
- Staff Costs
- Other Operating Expenditure
- Interest & Finance Costs
I appreciate I could achieve this by creating a sort column on the dimension but I'm looking to not have to apply the sort on every report that I create as there will be many.
Any help would be much appreciated.