How to sort table rows by a columm that is not group-by column/value column

[jjc]

how to sort a table from a column that is not group-by nor value column. I put conditional formatting to a value column but I want to sort by absolute value (another calculated column not in the table visual), is there a workaround?

[Reid]

Without seeing the full picture, I will give you an idea of what can be done.

Let’s say to the left you have a row named “customer” -

Click on “customer” and sort AtoZ based on (amount_reconciled) and it should automatically sort the “customer” based on the gradient formatted values.

[jjc]

Thanks Reid for pointing it out. Attach a snippet for anyone who may have the same question