small multiple sort

[chiyow2828]

Hi, 

I tried using small multiples based on company and spend. 

I got the table below. 

However, the x-axis is sorted alphabetically. 

Is there a way so that I can sort the x-axis according to the total amount (Y-AXIS), kind of like a pivot chart?

[MFelix]

Hi @chiyow2828 ,

You cannot do that sorting because the usage of small multiples implies a share X-axis so the values are all sorted by the axis and not the values that way the values are comparable in terms of order.