Automate sorting

[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.

[#2]

What are your current settings in Chart Properties > Sort?

[zagzebski]

Jan - numeric value descending, then Feb - numeric value descending, then Mar - numeric value descending, etc.

Also allow interactive sort is checked.

[#4]

You can use variables in the Sort expression.  Do you have a sample file?