Sum, maximum, mean or median? How to handle values
In your datasheet there may be only one value for rows with the same origin and destination. However, this is often not the case. What if you need to only show the highest of a range of values, or calculate their sum, mean or median?
TIP:: The mean is the sum of the numbers in the set divided by their amount.
The median is the middle point of a value set, in which half the values are above the median number and half are below. If your value set features an even number of numbers you are able to calculate the median by the two middle numbers and dividing by 2.