Sorting of months in cross tab

[sudhakar111]

Hi all,

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?

 

[vanessafvg]

in your modelling tab set the monthname  column to sort by column by month number 

[sudhakar111]

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

till 2017-Mar.

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.

[Anonymous]

Hi @sudhakar111,

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"))

Regards,
Xiaoxin Sheng

[sudhakar111]

Thanks for the response. But i need to display the months as 2016 - Apr,2016 - May and so on and not in numbers.