Man illustrationFlower illustration

Pivot

Estimated reading: 2 minutes 184 views

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


*Excel nameThe reference name of the excel file which has already been opened or created is chosen in the dropdown.
Source sheetThe Excel sheet name which includes data for the pivot is written.
RangeThe information for the range to be pivoted is given.
Sheet nameThe name of that sheet is given to show the result of the Pivot operation on a blank Excel sheet or a newly created Excel sheet.
DestinationIt can be determined from which cell the pivoted data will be written in excel.

Note: If no destination is given, the copy is made to cell A1.
ColumnsIt gives which columns will consist of in the pivot operation.
RowsIt gives which rows will consist of in the pivot operation.
ValuesThe desired action is written.
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

A,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.

Share this Doc

Pivot

Or copy link

CONTENTS
Chat Icon Close Icon