ajay_chothani Posted August 14, 2014 Share Posted August 14, 2014 Hi,I have requirement that I am using Year,Month(like January,February,..etc), and a measure lets say Count(*) on the Ad hoc. When I drag Year and Month, the Month is getting sorted alphabetically, However I want to sort it in time wise(like January then Feburary then March).Is there any way that I can sort Month without dragging any additional column(like Monthkey) and perform sorting based on that.Appreciate your suggestions.Thanks,Ajay Link to comment Share on other sites More sharing options...
djohnson53 Posted August 18, 2014 Share Posted August 18, 2014 The short answer is no. What I do in these cases is to create a string field like "01 January" and "02 February" or "Month 01 (Jan)" or so - whatever would look the best as a label to the graph. But there's no way, that I know of, to separate the label on the axis from the data being sorted. Link to comment Share on other sites More sharing options...
lemmens.mattias Posted April 27, 2015 Share Posted April 27, 2015 Some Syntax would be nice cause i cant get it to work. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now