I am facing problem in sorting the dimension. I have monthly data which i want to sort in reverse order on the basis of months. For eg. I have sales data for Nov'16, Dec'16, Jan'17, Feb'17. Now, i want to sort this data in visualization in such a way that Feb'17 should come first for current year followed by Jan'17, Dec'16, Nov'16.
Can you guys help me??
Is your [Month/Year] field a date field or text? If it is a date field then you can do a numeric value sort by descending order. If it is text than you can put this as your sort order in the expression:
=Match([Month/Year], 'Feb-17', 'Dec-16', 'Nov-16')
OR you can create a custom SortORder by loading an inline table associated with the field you want to sort
and then sort by expression
Load * Inline [
Now sort by expression Month_SortOrder
Thanks a lot for the suggestion but still it is not solved. I tried this but still the result is coming as Dec'16 first followed by Feb'17, Jan'17 and Nov'16
There are few options you can do