Absent Member.. AlfredoMonasi Absent Member..
Absent Member..
536 views

Sorting Columns in Pivot Portlet

Jump to solution

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

 

Tags (1)
0 Likes
1 Solution

Accepted Solutions
Highlighted
Absent Member.. AlfredoMonasi Absent Member..
Absent Member..

Re: Sorting Columns in Pivot Portlet

Jump to solution

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

0 Likes
2 Replies
Derek Giedd Honored Contributor.
Honored Contributor.

Re: Sorting Columns in Pivot Portlet

Jump to solution

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)
0 Likes
Highlighted
Absent Member.. AlfredoMonasi Absent Member..
Absent Member..

Re: Sorting Columns in Pivot Portlet

Jump to solution

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

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.