Required help in "sorting row headers in matrix visualizations"

[SKYGOLD]

Hi Team,

I'm currently building a report with an Account Hierarchy that needs to be sorted in the Row headers of a matrix visual. When I apply the "Sort by column" option to the Sequence column under the Data tab, it's not working as expected.

Please help to provide any alternative solutions or suggestions to achieve the desired sorting?

Note : The columns are organized by Calendar year and month, and the values are displayed in the rows. And the Column headers are correctly sorted by Year and Month Name (e.g., JAN, FEB, ..., DEC)

Level 1	Level 2	Level 3	Sort Order
Property Revenue	Property Revenue	Student Rental	1
Property Revenue	Commercial Rental	Commercial Rental	2
Property Revenue	Ancillary Income	Ancillary Income	3
Property Expenses	Bad Debt Expense	Bad Debt Expense	4
Property Expenses	Operations Expenses	Sales Expenses	5
Property Expenses	Operations Expenses	Marketing Expenses	6
Property Expenses	Operations Expenses	Utilities Expenses	7
Property Expenses	Operations Expenses	Resident Services	8
Property Expenses	Operations Expenses	Operations	9
Property Expenses	Operations Expenses	Wellness & Hygiene	10
Property Expenses	Operations Expenses	Facilities Maintenance Expenses	11
Property Expenses	Operations Expenses	Technology & Overheads	12
Property Expenses	Operations Expenses	Statutory & Insurance	13
Property Expenses	Operations Expenses	Land Tax Surcharge	14
Property Expenses	Operations Expenses	Payroll - HQ Recharge	15
Property Expenses	Operations Expenses	Payroll - Building Level	16
Property Expenses	Operations Expenses	Catering	17
Property Expenses	Operations Expenses	Strata Fees	18
Property Expenses	Ancillary Expenses	Ancillary Expenses	19
Property Expenses	Property Management Fees	Property Management Fees	20
Non-Property Revenue	Other Income	Interest Income	21
Non-Property Revenue	Other Income	Other Income	22
Non-Property Revenue	Distribution Income	Distribution Income	23
Non-Property Expenses	Investment Management Fees	Investment Incentive Fee	24
Non-Property Expenses	Other Management Fees	Supplemental Fee	25
Non-Property Expenses	Finance & Borrowing	Agency Fees	26
Non-Property Expenses	Administrative Expenses	Finance & Indirect Costs	27
Non-Property Expenses	Finance & Borrowing	Interest Expense	28
Non-Property Expenses	Finance & Borrowing	Borrowing Costs	29
Non-Property Expenses	Depreciation and Amortisation Expense	Depreciation & Amortisation	30
Non-Property Expenses	Indirect Expenses	Investment Prop. Gain/(Loss)	31
Non-Property Expenses	Indirect Expenses	Unrealised Derivs. Gain/(Loss)	32
Non-Property Expenses	Indirect Expenses	Realised Derivs. Gain/(Loss)	33
Non-Property Expenses	Administrative Expenses	Interstaple Lease	34
Non-Property Expenses	Distribution Paid	Distribution Paid	35
Non-Property Expenses	Tax Expense	Tax Expense	36

FYI, Here is the information I currently have. However, I am seeking a specific order sequence based on the column sequence provided. This ordering should apply to all hierarchy levels, not just the top level.

[SKYGOLD · Accepted solution]

Thanks Team, I want to share that I've successfully discovered an alternative solution to the challenge. By incorporating a sequence as the initial value and then calculating its minimum, I was able to apply a sort order to achieve the desired result. Consequently, I have hidden this field to ensure a neat and user-friendly presentation of the data.

Just wanted to keep you informed. Thank you!

FYI,