Custom order in Pivot Table

Get Help
1

Hi,

I would like to order the transaction type, according to deposits, refunds, chargebacks, and then Chargeback reversals.

But currently I'm only able to order alphabetically.
I could maybe do a case, and rename each transaction type name, so that it is alphabetical, or add a separate field, but it seems that's messy.

Is there a way to order these rows with a custom order rule?

image
image974×689 42.9 KB

TIA!

2

You can't sort by value when using pivot tables unfortunately. See Pivot table - sort by value · Issue #16505 · metabase/metabase · GitHub

3

Hi @dahyeikim , thanks for the confirmation.
Hopefully that feature will be implemented soon.