chapter 8 : Grouping

1. Group By Sum

Group by Sum adds all values in each group.

Example

RegionSales
East100
East200
West150
West250
West100

Result (Group by Sum):

RegionTotal Sales
East300
West500

Explanation

  • East: 100 + 200 = 300

  • West: 150 + 250 + 100 = 500