[]
Spread.Slicers.SlicerAggregateType
Represents the aggregate type.
• average = 1
Calculates the average of the specified numeric values.
• count = 2
Calculates the number of data that contain numbers.
• counta = 3
Calculates the number of data that contain non-null values.
• max = 4
Calculates the maximum value, the greatest value, of all the values.
• min = 5
Calculates the minimum value, the least value, of all the values.
• product = 6
Multiplies all the arguments and returns the product.
• stdev = 7
Calculates the standard deviation based on a sample.
• stdevp = 8
Calculates the standard deviation of a population based on the entire population using the numbers in a column of a list or database that match the specified conditions.
• sum = 9
Calculates the sum of the specified numeric values.
• varp = 11
Calculates the variance based on a sample of a population, which includes numeric, logical, or text values.
• vars = 10
Calculates the variance based on a sample of a population, which uses only numeric values.