The order in Matrix table

Question

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",&nbsp;when I click the header of any "Value".&nbsp;I have created a column called : [Rollup Account Category Order], and set the "Sort by Order" of&nbsp;[Rollup Account Category] based on&nbsp;[Rollup Account Category Order], but I can not achive my goal in the report.How can I achive that?&nbsp;Thank you!BrankoRollup Account CategoryRollup&nbsp;Rollup Account Category OrderAmountSALARIESEmployer Contributions126407.54SALARIESSalaries &amp; Wages - Overtime199.18728SALARIESSalary Permanent Positions1120292.9SUPPLIESAchievement Awards20.890459SUPPLIESAdvertising20SUPPLIESContract Services29640.873SUPPLIESEmployee Travel21181.382SUPPLIESHonoraria210.60071SUPPLIESHospitality, Corporate Event &amp; Working Session2500.6784SUPPLIESInsurance Expenses2144.0177SUPPLIESIT Services21469.756SUPPLIESLegal Expenses218160.32SUPPLIESMaterials &amp; Supplies2109.0389SUPPLIESMiscellaneous2286.8763SUPPLIESMLA Expenses2181.2438SUPPLIESOffice Equipment &amp; IT Supplies2632.53SUPPLIESOther Employee Expenses2664.6502SUPPLIESOther Services21059921SUPPLIESPublications Expenses22050.876SUPPLIESRental2320.9081SUPPLIESRepairs &amp; Maintenance2101.3039SUPPLIESTelephone and communications2448.0035OTHERAllowances &amp; Benefits3703.5194OTHERAmortization of Tangible Capital Assets3257.4346OTHERCapital Asset Acquisition30OTHERGrants3599803.6OTHEROther Expenses3-1116.86&nbsp;

anonymous · Accepted Answer

Hi&nbsp;brankocareer&nbsp;,
&nbsp;
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.&nbsp;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.&nbsp;

Of course, this workaround may also have limitations, which require further testing, but for now it is perfect.
&nbsp;
Best Regards,Stephen TaoIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Forum Discussion

The order in Matrix table

1 Reply

Related content

Matrix table

Matrix component - order question

Table Sort , sort order , comparer

matrix rows order

order a matrix

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