Forum Discussion

chiyow2828's avatar
chiyow2828
Frequent Visitor
2 years ago

small multiple sort

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?

 

 

1 Reply

  • MFelix's avatar
    MFelix
    Super User
    2 years ago

    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.