Pivot Table is another powerful tool supported by SpreadsheetLIVE to analyze large data sets.
There are four main components of a Pivot Table:
- Page controls are placed on the top of the Pivot Table and allows filtering source data with respect to selections
- Row control filters the number of rows listed in the Data section
- Column control filters the number of columns listed in the Data section
- Data is the calculation section of a Pivot Table. Data field must be numerical. SpreadsheetLIVE currently supports Sum, Average, Count operations.
