Forum Discussion
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...
I found the solution on YouTube! Link: https://youtu.be/RDXvpE3V5m0?si=NA5s7BVR5Xu9yy6g
Hi Anonymous,
I can offer you to create a sorting option like this one:
With your real data it can be more complicated.
Once done, you can add it to Tooltips, then it will be available among the sorting options.
If you drill down, you will get what you want with subcategories:
Best Regards,
Alexander
Hi barritown
Thanks for this. However, as you've expected, my data is a bit more complicated, hence I'm unable to get the expected result. Thank you very much for your work book as reference too.