Unstack/Pivot Table Improvements

(ORG-3656)

Better Support of Other Columns in Unstack

(ORG-4606)

When unstacking columns in a worksheet, "other columns" were not handled properly in previous version.

Origin 9.1 introduce options to handle data in other columns properly

  • Matching Longest Group (same operation as 90)
  • Combining All Groups

 

 

Pivot Table Improvements

Pivot table is improved to have proper logic when handling the cases for combining smaller values

Improve Sorting Order Issues in Pivot Table (ORG-8280)

  • Sort results by Row/Column Totals does not work correctly if row/column total is not output.
  • Sort labels ascending as the secondary sort sequence when total values are equal.
  • Sort by numeric value when source data is Month/Day of Week format.