Man illustrationFlower illustration

Docy

Pivot

Estimated reading: 2 minutes 81 views

Pivot activity is used for pivot operations that will be done in an Excel file.


*Excel nameThe name of the Excel file that was opened or created before is selected.
Source sheetThe Excel sheet that will be retrieved data.
RangeExcel sheet range from which to fetch data.
Sheet nameName of the sheet to work in Excel. If not added, it takes the first sheet by default.
DestinationSets destination cell on which the operation will write the results.
ColumnsIt gives which columns will consist of in pivot operation.
RowsIt gives which rows will consist of in pivot operation.
ValuesThe desired action that will be done in the pivot.
Note: * Fields selected with are required, others are optional.

You can use the Excel name as shown in the example.

${pivotExcel}

You can use the Source sheet as shown in the example.

Sheet1

You can use the Range as shown in the example.

A1:B3

A:A

A:H

You can use the Sheet name as shown in the example.

Pivot

You can use the Destination as shown in the example.

A1

You can use the Columns as shown in the examples.

A

A,B

You can use the Rows as shown in the example.

B

You can use the Values as shown in the examples.

SUM(C)

COUNT(C),AVERAGE(C)

Supported functions:

AVERAGE

COUNT

COUNT_NUMS,

MAX

MIN

PRODUCT

STD_DEV

STD_DEVP

SUM

VAR

VARP

If the first page of the excel files will be pivoted, the source sheet field does not have to be filled. Otherwise, it must be filled.
If no Destination is given, it is copied to cell A1.
If Range is not given, the entire range in the Excel file is taken.

CONTENTS