You don’t need more effort; you need better formulas.
Microsoft Excel’s PIVOTBY function, now available in Microsoft 365, streamlines the creation of dynamic data summaries without the manual refreshes and rigid layouts of traditional PivotTables.