Find the median of a column or group.
numbers (required) The column of numbers to be evaluated.
NOTE: If there is an even number of values, Median will interpolate between the middle values.
- Find the median temperature value. If the column values were 3, 5, 7 and 20 the result would be 6.
More About Aggregate Functions
If the column being aggregated is grouped, then the aggregate is computed for each group. For example, if the worksheet is grouped by the column [Year], then placing Sum([Revenue]) on the [Year] level computes the revenue for each year.
The results of aggregate functions can be referenced by lower levels. An example would be to create a Sum([Amount]) column as Total and then an [Amount] / [Total] column as Percentage. This converts each Amount value into a relative percentage value.