Pivot contents

Pivot overview

Pivot rows and pivot columns


Settings of pivot contents

Specify the body of the pivot table from the grouped data.
A black right arrow is displayed after entering the display string in the pivot contents. Click the arrow, the settings dialog of the pivot contents is popped up and can be edited.

 

Label

Pivot label is displayed in the red rectangle box as follows. It is usually used to display the code of pivot body or the code of grouped data.

 

Displayed content expression

Specify the body of the pivot table. The expression as follows, means the pivoted object.
ME.ASGPivotData_MemberObject
Please refer to following examples.

<Example> Items and customers are grouped in order table.

Total no of order quantity: Sum(ME.ASGPivotData_MemberObject,TARGET.Order_Qty)

 

<Example> Items and customers are grouped in order table.

Total no of order object: PropCount(ME.ASGPivotData_MemberObject)

 

<Example> Items and start days are grouped in operation table.

Inventory quantity: CalcInventory(ME.Item,ME.StartTime)

 

Initial value

It is available when the data type of "Group key" is date type. Specifies the initial value.
If the initial value is specified, one column is inserted. The initial value is displayed in the inserted column. For example, it is specified with the expression as follows.
CalcInventory(ME.Item,PROJECT.BasisTime)

 

Show zero values

In case of "Yes", "0" is displayed when the value is null or zero.
In case of "No", nothing is displayed when the value is null or zero.

 


HelpNo.:740640
©2016 Asprova Corporation, All rights reserved.