Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Sorting Columns in Pivot Portlet

SOLVED
Go to solution
Highlighted

Sorting Columns in Pivot Portlet

Hi Everyone,

 

I'm making a Pivot Portlet where rows are order according to my query sort, but dinamic columns seems to sort again according the field description instead of keeping the sort of the query, for example my query is the following:

 

 

Category 1               January 2014

Category 1               February 2014

Category 1               August 2014

Category 2               January 2014

Category 2               February 2014

Category 2               August  2014

Category 3              January 2014

Category 3               February 2014

Category 3               August 2014

 

My expected sort will be something like this

   

                                    January 2014      February 2014    August 2014

Category 1

Category 2

Category 3

 

But instead is showing this:

 

                                    August 2014      February 2014    January 2014

Category 1

Category 2

Category 3

 

There is a way to keep the order of the dynamic columns or resort columns by a condition.

 

Regards

 

Alfredo

 

2 REPLIES
Derek Giedd
Frequent Visitor

Re: Sorting Columns in Pivot Portlet

PPM is sorting by the month name and not by the month number.  You may need to add a column containing the month number and sort on this.

-- Remember to give Kudos to answers! (click the KUDOS star)
Solution

Re: Sorting Columns in Pivot Portlet

Hi Derek,

 

Actually the datasource had the sorting, the pivot table dont have a sort option, but despise having the sort by year and month num PPM sorted again by month name, I had to change the column tag for YEAR-MONTH to solve it.

 

Regards,

 

Alfredo

//Add this to "OnDomLoad" event