Can You Build Formula-Based PivotTables? Now You Can With PIVOTBY! For years, I’ve said that PivotTables are Excel’s best feature. Their near-limitless number of ways to summarize without writing formulas allows us to create reports summarizing vast data volumes. However, in some cases, the structure associated with PivotTables limited users. For instance, arranging a PivotTable report into a particular format can be problematic, as can generating calculations in the PivotTable outside of the eleven provided summarization options. Fortunately, Excel’s new PIVOTBY function addresses these issues and allows you the flexibility to build your reports precisely the way you want! What…
