Excel's PIVOTBY function allows you ... came from people watching basketball. As well as using SUM, AVERAGE, and PERCENTOF for the function argument in PIVOTBY, you can also use other aggregation ...