Cross Tab Row Sort

[grecon]

I have a Cross Tab and the Row lists months with the year - what I would like is for it to list the same month of different years under each other - is this possible? It would make it easier to compare the values of each year.

Like this :

Jan 2018
Jan 2019
Feb 2018
Feb 2019

Thanks

 

[SkipVought]

You have strings. What you need are formatted dates.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

 

[lbass]

If you use a date field for your row as Skip suggests, you can format it to appear as you show in your post. To get the order you want, you could have an outer row (#1) field based on month, and then an inner row (#2) field based on year.

-LB