12 Replies Latest reply: Jun 2, 2014 2:25 PM by Blair Gibb RSS

    Month vs. MonthName sorting issue

      Hi All,


      This appears to be a bug, but I thought I would do a sanity check first.  I created a small worksheet that just has data for 13 months, and a value to sum.  I created two charts to show the sums.  I put a sort value of =[Position Date] in the Expression for both.


      If I use MonthName([Position Date]) as an expression for the dimension, it sorts correctly.  I use Month([Position Date]), it puts the data for May 2014 first in the chart, followed by the other months in correct order.


      I have attached the application - if anyone can tell me why this is, and how to get the sort to work correctly, I would greatly appreciate it.