Pivot Value Dialog
Use this dialog to specify aggregations for values in your pivot table.
options
|
Field
|
Description
|
|
Summarize value field by
|
Instructs Monarch Classic to apply any of the following functions to the values:
-
Sum - The sum of the values. This function is the default for numeric data. If the field being aggregated contains blanks or non-numeric data, the Count function is applied instead.
-
Count - The number of non-empty values. This function is the default for data types other than numeric.
-
Average - The average of the values.
-
Max - The largest value.
-
Min - The smallest value.
-
Product - The product of the values.
-
CountNums - The number of data values as numbers
-
StdDev - An estimate of the standard deviation of a set of values.
-
StdDevp - The standard deviation of all of the values.
-
Var - An estimate of the variance of a set of values.
-
Varp - The variance of all of the values.
|
|
Show value as
|
-
Normal - Displays the value entered in the field
-
% of row - Displays the values in each row as a percentage of the row total
-
% of column - Displays the values in each column as a percentage of the column total
-
% of total - Displays values as a percentage of the grand total of all values
|
|
Number format
|
Applies a number format to the values (General, Thousands, Currency, Percentage, Time Span)
|
|
Decimals
|
Specifies the number of decimal places to add to the values.
|
