C3 - Pivot Table with More than 1 Source for Column or Row

Owned by Cecilia Shi
Last updated: Nov 07, 2017 by Wall-E

ORG-10259

Sample OPJ to download to try:  C3 Folder of 92DemoOthers.opj

 

 


Origin 2015 supports multiple columns or rows in pivot table as data source. It helps user to summarize data by combination of multiple columns/rows


How to:

  1. When a worksheet is active, select menu Worksheet: Pivot Table
  2. More than 1 column can be selected as Pivot Table Row/Column Source.
    Note: When Options: Sort Output Rows/Columns select None, user can set the Row/Column Source column(s) as categorical, then the order in result table will be changed accordingly.