Portfolio Analyzer, dates out of sequence

[Greg Horodeck]

I apologize if this is sent twice.



I have a Portfolio Analyzer view that is displaying the date (months) data
out of sequence.



The range of my data spans May 2003 through March 2004. Both the Pivot Table
and Chart display the dates in the following sequence;

Jan 2004, Feb 2004, Mar 2004, May 2003, June 2003, July 2003, etc through
Dec 2003.



While I understand that the month of January comes before May in the
calendar, January 2004 is after May 2003.



Is this a bug or feature? Is there an option or technique I can use to
correct this other than making the data span 13 months (which is longer than
what we generate for the cube)?





Greg

 

[Dale Howard]

Greg --

Right-click on the Months field name header in the Pivot Table. Is the
"Sort Ascending" option checked? If not, check it. Let me know if this
helps or not.