Bar Chart - Sort Binned Bars by Value
I'm curious if it's possible to sort binned bars (by date) by value. Basically I have a grouping of dollars by month by category and I want to be able to sort the values descending within each month. When I choose to sort bars by value in the current chart, it doesn't keep the month bin, but sorts all values descending no matter the timeframe.
I've attached two pics, one for the default output and one with the desired output. Any info or examples greatly appreciated.
Thanks in advance!