3 Replies Latest reply: Nov 8, 2012 5:06 PM by Rebecca Molstad RSS

    Automate sorting

    Steve Zagzebski

      I have a chart with an expression for each month. My sort order is January, then February, then March, etc. When I select a month (say October) I have a condition that hides any month that is not equal to the selection. However the sort order is still based on January.

       

      Is there a way, in my example above, to keep the sort order by month, but when I select on October it sorts on October, then when I deselect October it goes back to sorting by Jan, then Feb, then March, etc.?

       

      Thanks in advance for any help.