Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Sort two columns on the same one column

I would like to create a bar chart with these columns: Category, Subcategory, Quantity   The x axis will be both Category and Subcategory.   The y axis will be Quantity.   I want to sort Catego...
Need Help
HarishKM's avatar
HarishKM
Super User
1 year ago

Anonymous Hey,
Kindly use cluster column chart for your requirmeent.

Please refer below example for your reference.


I am following below steps.

select Cluster column chart

drag your cat and sub cat to x axis

drag your QTY measure to value.

select three dot on right side - select sort by QTY then select ASC order to sort as per your requirment.

 

Thanks

Harish M

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Add snapshop for your reference

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi HarishKM 

    • Unfortunately this will not work for me because if you were to set the subcategories quantities to be different, for example if bb is more than aa but bb2 is less than aa1, the categories would be sorted according to the quantities so the sub category of bb2 will be before aa1, causing the category not sorted by quantity