Pivot Table dialog box¶
This dialog box appears when the
Pivot Table command is selected. 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. 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. Selects the column of the CSV document to be extended to the rows in a new pivot table. 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. Selects the column of the CSV document to be extended to the columns in a new pivot table. 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. Selects the column of the CSV document to be extended to the values in a new pivot table. 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. 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. Specifies the number of rows used as the header.Type drop-down list box¶
Decimal places text box¶
Rows drop-down list box¶
Sort drop-down list box¶
Columns drop-down list box¶
Sort drop-down list box¶
Values drop-down list box¶
Total in columns check box¶
Total in rows check box¶
Header drop-down list box¶