Custom Sort in Matrix

[wulawula]

Hello, I have encounter a problem on how to custom sort columns just as what I can do in Excel files.

I have 3 columns to show on the Matrix. I want to show column A in ascending order and column C in descending order grouped by column A as the table showed below.

Column A	Column B	Column C
Agency	F	100000
	C	90000
	E	80000
	D	70000
	B	60000
	A	50000
Self-Pay	C	75000
	D	65000
	B	60000
	A	50000
Worker's Comp	A	85000
	B	35000

I know many people may asked about the similar questions about custom sort in Matrix. I tried to use ISONORAFTER function to get the order but it's not working for me. Is there any other helpful functions can be used in the case? Thank you so much!

[SpartaBI]

Why don't switch to Table visual instead of a Matrix and than you could do any combination of sorting you want by:
1. Sort Coulmn A asceding 
Hold shift key and:
2. Sort Column C descending

[wulawula]

Thanks @SpartaBI . Yes, that's what I thought too. But what can we do if the end user prefers the Matrix layout? Matrix is nice and neat without showing repeat items.

[SpartaBI]

Than you should change the end user 😂

You can maybe create a sortby column for Column B that will be the negative number of the Column C value and than sort Column B by it, and the Matrix will be sorted the way you want, but this will work only if we are talking about a static situation where the values of colunn won't change their sorting based on different filter context. WDYT? 

[wulawula]

Thank you! That works if it's a static list and I'm trying to think it through since the data is dynamically changed.