I have an issue with sorting of months in a cross tab.Need to display the year and month.
But by default it is displaying in alphabelital order. Do we have any work around?
in your modelling tab set the monthname column to sort by column by month number
Proud to be a Super User!
Thank you vanessafvg. I tried it but still it is displaying in alphabetical order.
My requirement is that the month should start with April. So for the financial year it will be 2016-Apr,2016-May and so on
The Year should be appended along with the month name.i tried sorting on year month number like 2016-04. it does not work even
if i remove the year.
You can try to add a calculate column to convert financial date to numeric, then drag above column to columns field, it may fix the issue.
Numberic Fiscal Date = VALUE(FORMAT([Date],"yyyymm"))
Thanks for the response. But i need to display the months as 2016 - Apr,2016 - May and so on and not in numbers.
Check out the on demand sessions that are available now!
Check out the Winners!
Features releasing from October 2020 through March 2021