PivotTables are static relics; PIVOTBY is the responsive, resilient, and fully auditable future of the modern Excel professional.
Prevent broken formulas using tables, validation rules, separate worksheets, named variables, and the power of LAMBDA.