Force Order for Data in View

Lawrence Brown shared this question ago

Answered

Hi,

I have a grouping for some financial data that occurs across multiple reports.

2eb8bfd3b87a1d596575fbd6f9a5ea3d

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
Depreciation
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.

The same question

Replies (3)

Guest ●

Hello,

This has already been filed for an enhancement (Task ID: 236183)

It is currently being worked on, but we do not have an ETA at this time.

Sorry for any inconvenience,

Best regards,

Pete

Reply URL

Guest ●

Hello,

I was looking into this issue a bit further for you and I believe you may be able to do what you are after by using "Org Reference Codes".

This would allow you to create a mapping between a value and an entry and also allow for custom ordering across multiple reports.

Please have a look at the manual entry below:

http://wiki.yellowfin.com.au/display/USER72/Org+Reference+Codes

Best regards,

Pete

Reply URL

Lawrence Brown ●

Hi Pete,

Thanks I did think that might be a possible solution, I'll give it a go an let you know how I get on.

Lawrence

Reply URL