Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try a sort expression like
=If(GetCurrentField( "New Group" )='Date', Date, -sum(Value))
Try a sort expression like
=If(GetCurrentField( "New Group" )='Date', Date, -sum(Value))
Check the attached
Both scenarios worked beautifully, thanks guys much appreciated