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
But instead is showing this:
August 2014 February 2014 January 2014
There is a way to keep the order of the dynamic columns or resort columns by a condition.
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.