Help needed to sort a Cyclic chart

[#1]

I am trying to sort out the sorting of a cyclic chart but with no luck. The chart starts with month and then category then product which all works marvelously. My issue is the sorting. I want the Month to obviously be sorted in month order, which I have, but then on the products and categories I want it sorted by value (descending). Any ideas on how to achieve this? Attached is a sample file

[swuehl · Accepted solution]

Try a sort expression like

=If(GetCurrentField( "New Group" )='Date', Date, -sum(Value))

[sunny_talwar]

Check the attached

[#4]

Both scenarios worked beautifully,  thanks guys much appreciated