Pivot overview

Steps

Pivot rows and pivot columns

Pivot contents

Pivot Table

Pivot table is used to summarize data from a table by grouping cells together.

A pivot table is made up from the following three data:

1. A property to be grouped for the vertical axis.

2. A property to be grouped for the horizontal axis.

3. The content to be displayed after grouping data from 1 and 2.

For example, the pivot table on the left is made by grouping 1: Customer, 2: Item, and shows the grouped values of 3: Order quantity.

 


Restriction

*Pivot summarized table cannot be exported directly, but it can be copied and pasted to external application. In addition, it can be exported by using COM interface. Pivot table export function has been implemented in the plug in collection and can be used directly.


HelpNo.:740600
© Since 2018 Asprova Corporation, All rights reserved.