18 Replies Latest reply: Sep 1, 2014 10:21 AM by Adam Davies RSS

    Advanced Sorting (by field not in dimension or epxression)

    Steve Zagzebski

      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.

       

      Any thoughts?