Group by Median finds the middle value after sorting the data in each group.
If there are two middle values, take their average.
East Sales: 100, 200
Median = (100 + 200) รท 2 = 150
West Sales: 100, 150, 250
Median = 150 (middle value)
Result
| Region | Median Sales |
|---|---|
| East | 150 |
| West | 150 |