Platform

 View Only

 New Column Order functionality

Jump to  Best Answer
  • TBMStudio
Dawn Kassube's profile image
Dawn Kassube posted 10/01/21 04:23 PM
Hello,

We just upgraded to Version 12.9.11 and I would like to know how to enable the "Other" Column Order functionality as only ascending and descending were available for selection.  

New Client features

Support column order for tables with pivoted columns

Enables TBMAs to set the desired column order (ascending, descending or customer order) for tables with pivoted columns. In Ad Hoc Component Configuration: Drag a metric into the Columns section (for a column pivot) then right click the metric, then select Order. [ODS-1099]

Thank you,
#TBMStudio
Suresh Sawlani's profile image
Suresh Sawlani  Best Answer
Hi @Dawn Kassube,

The new feature that was introduced was actually, "Ascending" and "Descending" ordering of columns in a pivot table. 

Previously, you could not control the order of the columns with a rule.  The columns were randomly ordered by report studio and could be manually re-ordered by dragging columns.

The "Custom" order is for display purpose only.  To see the behavior in action, click on Ascending and the columns will sort Ascending.  Now, manually drag a column to a different position.  Returning to the right click menu above, you will see "Custom" is selected.

#TBMStudio