Categories
Sort graph by month
Hi Sir,
I tried creating the graph below using the month column created from the Calendar/Date function.
Is there a way to sort the month, Jan, Feb, Mar etc in Enterprise Edition 11.1.1.7 analysis?
Thank you for your help.
Answers
-
Sorting is alphanumeric. You have to either sort on another column which represents the month as a number 1 - 12 or prepend the number to the name "01 - January" or the likes.
0 -
Or model your data correctly by setting the sort order column for your "month name" column in the RPD.
By the way, you have a bunch of open thread without any feedback, you should consider taking 5 minutes to go back there and check if you got what you looked for and close threads if needed (because remember this is a community forum: you take and you give, you closing threads is part of giving).
0
