[NetMageSCW]

The advantage of Pivot Tables is they are interactive, but (modern) dynamic array formulas are better in cases where you are producing a static result.