PIVOTBY is great for analysis, but PivotTables still have the edge when formatting needs to adapt to data changes.
Before you blame Excel, check whether your formulas are scanning a million empty rows.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results