Show/Hide Toolbars

EmEditor Help

Navigation: EmEditor Help > Dialog Boxes

Dialog: Pivot Table dialog box

Scroll Prev Top Next More
EmEditor Home - EmEditor Help - Dialog Boxes

Pivot Table dialog box

This dialog box appears when the Pivot Table command is selected.

Type drop-down list box

Selects the type of a pivot table to be created.

Count

Counts the occurrences.

Sum

Sums the values.

Average

Calculates the average of all values.

Max

Maximum value.

Min

Minimum value.

Decimal places text box

Specifies the decimal places if Sum, Average, Max or Min is selected in the Type drop-down list box. If 0 is specified, all values are treated as integers, and any digits right of the decimal point are ignored.

Rows drop-down list box

Selects the column of the CSV document to be extended to the rows in a new pivot table.

Sort drop-down list box

Selects the sort method of the new rows (the first column of each row).

Sort A to Z

Sorts strings in ascending order.

Sort Z to A

Sorts strings in descending order.

Sort Smallest to Largest

Sorts numbers in strings in ascending order.

Sort Largest to Smallest

Sorts numbers in strings in descending order.

Sort Shortest to Longest

Sorts strings by length in ascending order.

Sort Longest to Shortest

Sorts strings by length in descending order.

Sort Fewest to Most Words

Sorts strings by the number of words in ascending order.

Sort Most to Fewest Words

Sorts strings by the number of words in descending order.

Sort Date and Time Oldest to Newest

Sorts date and time in strings in ascending order.

Sort Date and Time Newest to Oldest

Sorts date and time in strings in descending order.

Sort by Occurrence Ascending

Sorts by occurrence in strings, in ascending order.

Sort by Occurrence Descending

Sorts by occurrence in strings, in descending order.

Sort IPv4 Addresses Ascending

Sorts IPv4 addresses in strings, in ascending order.

Sort IPv4 Addresses Descending

Sorts IPv4 addresses in strings, in descending order.

Sort IPv6 Addresses Ascending

Sorts IPv6 addresses in strings, in ascending order.

Sort IPv6 Addresses Descending

Sorts IPv6 addresses in strings, in descending order.

Columns drop-down list box

Selects the column of the CSV document to be extended to the columns in a new pivot table.

Sort drop-down list box

Selects the sort method of the new columns (the first row of each column).

Sort A to Z

Sorts strings in ascending order.

Sort Z to A

Sorts strings in descending order.

Sort Smallest to Largest

Sorts numbers in strings in ascending order.

Sort Largest to Smallest

Sorts numbers in strings in descending order.

Sort Shortest to Longest

Sorts strings by length in ascending order.

Sort Longest to Shortest

Sorts strings by length in descending order.

Sort Fewest to Most Words

Sorts strings by the number of words in ascending order.

Sort Most to Fewest Words

Sorts strings by the number of words in descending order.

Sort Date and Time Oldest to Newest

Sorts date and time in strings in ascending order.

Sort Date and Time Newest to Oldest

Sorts date and time in strings in descending order.

Sort by Occurrence Ascending

Sorts by occurrence in strings, in ascending order.

Sort by Occurrence Descending

Sorts by occurrence in strings, in descending order.

Sort IPv4 Addresses Ascending

Sorts IPv4 addresses in strings, in ascending order.

Sort IPv4 Addresses Descending

Sorts IPv4 addresses in strings, in descending order.

Sort IPv6 Addresses Ascending

Sorts IPv6 addresses in strings, in ascending order.

Sort IPv6 Addresses Descending

Sorts IPv6 addresses in strings, in descending order.

Values drop-down list box

Selects the column of the CSV document to be extended to the values in a new pivot table.

Total in columns check box

Displays the total value of each column at the bottom row. If this is set, enter the label to be used for the first column of the row.

Total in rows check box

Displays the total value of each row at the rightmost column. If this is set, enter the label to be used for the first row of the column.

Header drop-down list box

Specifies the number of rows used as the header.

Copyright © 2003-2022 by Emurasoft, Inc.