The order in Matrix table

[brankocareer]

Hi,

In the matrix table , there are 2 items under "Rows" : [Rollup Account Category ] and [Rollup], my goal is:
1. The order of [Rollup Account Category] is fixed.
2. The order of [Rollup] dynamically changes based on sorting of any "Values", when I click the header of any "Value".

I have created a column called : [Rollup Account Category Order], and set the "Sort by Order" of [Rollup Account Category] based on [Rollup Account Category Order], but I can not achive my goal in the report.
How can I achive that?

Thank you!

Branko

Rollup Account Category	Rollup	Rollup Account Category Order	Amount
SALARIES	Employer Contributions	1	26407.54
SALARIES	Salaries & Wages - Overtime	1	99.18728
SALARIES	Salary Permanent Positions	1	120292.9
SUPPLIES	Achievement Awards	2	0.890459
SUPPLIES	Advertising	2	0
SUPPLIES	Contract Services	2	9640.873
SUPPLIES	Employee Travel	2	1181.382
SUPPLIES	Honoraria	2	10.60071
SUPPLIES	Hospitality, Corporate Event & Working Session	2	500.6784
SUPPLIES	Insurance Expenses	2	144.0177
SUPPLIES	IT Services	2	1469.756
SUPPLIES	Legal Expenses	2	18160.32
SUPPLIES	Materials & Supplies	2	109.0389
SUPPLIES	Miscellaneous	2	286.8763
SUPPLIES	MLA Expenses	2	181.2438
SUPPLIES	Office Equipment & IT Supplies	2	632.53
SUPPLIES	Other Employee Expenses	2	664.6502
SUPPLIES	Other Services	2	1059921
SUPPLIES	Publications Expenses	2	2050.876
SUPPLIES	Rental	2	320.9081
SUPPLIES	Repairs & Maintenance	2	101.3039
SUPPLIES	Telephone and communications	2	448.0035
OTHER	Allowances & Benefits	3	703.5194
OTHER	Amortization of Tangible Capital Assets	3	257.4346
OTHER	Capital Asset Acquisition	3	0
OTHER	Grants	3	599803.6
OTHER	Other Expenses	3	-1116.86

[v-stephen-msft · Accepted solution]

Hi @brankocareer ,

Thanks for reaching out to us.

In a table visual, you can sort by combination, for example, first by Rollup Account Category, then fixed, and then by Amount.

But, in a matrix, you can't do that, it's by design. You can either combine the Rollup Account Category and Rollup in the row to sort or sort the amount separately.

Here, the workaround is: go to data view, sort Rollup by Amount. 

Of course, this workaround may also have limitations, which require further testing, but for now it is perfect.

Best Regards,
Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly