sort by month on pivot report
I have a pivot report where customers are listed alphabetically in rows, and
the columns are sorted alphabetically, too. Trouble is, the columns are
months, and I want to sort Jan, Feb, etc, but it's sorting alphabeticcally.
The column headings come from a datamart list and are : Apr 05, Aug 05, and
so on on. Is it the "05" that won't let me sort by month? Any work arounds?
|