I am currently displaying the Month in the top of the cross tab.
I am using Month([Date]) to display date. I can use a custom sort and get it to put the months in the Right order and not ABC order.
I need to add the year to it… So it reads “DEC 2011” “JAN 2012” “FEB 2012” going across.
I can’t build a custom sort easy as this will change depending on the date range the user selects. Data is updated daily.
How can I build a MMM/YYYY variable on the report side that will display in correct order? Worst case senario I can update the universe itself, but want this as last option.
Another way to do it is to combine year and month number (as a numeric) and put that above the row with the alphanumeric representation, paint it white and sort on that row.
The easiest way is just to use the original date object in date format and use the format number properties to display as Mmm yyyy then apply the default sort A-Z and it will be in date order. Once you convert it to the string then it will only to alpha sort as it’s not longer a date and then you’d need to do custom sort to get that in order, which is a pain if you have year in there too who wants to do all that work?
(BOB member since 2010-05-03)
(BOB member since 2005-06-08)