Advanced Sorting (by field not in dimension or epxression)
I have a field that I want to sort by but I don't want it in my chart.
My chart: Dimension is Month and expressions are previous 12 months, previous 13-24 months etc. So currently I have data through August so each expression will just have the total of September - August (the last 12 months and so on). I know I could us the match function in the expression area of sort but that would have to be changed every month then and need to be dynamic in case the selection was different. What I really want to do is sort by my MonthYear field 201309, 201310, etc. but not have it anywhere in the chart because it is doesn't allow for expressions to be on the same line since the year is included.