Public Function New( _
   ByVal in_table As Object, _
   ByVal fields As Object, _
   ByVal pivot_field As Object, _
   ByVal value_field As Object, _
   ByVal out_table As Object _
)

Visual Basic (Usage)	Copy Code
Dim in_table As Object Dim fields As Object Dim pivot_field As Object Dim value_field As Object Dim out_table As Object   Dim instance As PivotTable(in_table, fields, pivot_field, value_field, out_table)

public PivotTable( 
   object in_table,
   object fields,
   object pivot_field,
   object value_field,
   object out_table
)

Parameters

in_table

The table whose records will be pivoted. (In, Required)

fields

The fields that define records to be included in the output table. (In, Required)

pivot_field

The field whose record values are used to generate the field names in the output table. (In, Required)

value_field

The field whose values populate the pivoted fields in the output table. (In, Required)

out_table

The table to be created. (Out, Required)

Reference