Summation Values are those values from our original table that are used to calculate the resulting value in the Pivot Table. In addition to the table column that is used to calculate the summation, we must specify a summation function that can combine the values together. It can be a sum, average, minimum, maximum, median etc. For example, selecting a Sale Amount and sum function will calculate the overall sales for the given Sales Person.