Twelve sales reps sit below a "Team average" row pinned above them. The grid only shows a few rows at a time, so scroll the body and the average stays put. Sort by revenue and the reps reorder underneath it, but the average row does not move and its figure does not change, because a pinned row is not part of the data. Read the full how-to on latticegrid.dev.