In this situation, you might consider converting your PivotTable to a formula-based report using Excel 2016’s new Cube-based functions and conversion tools. Once converted to formulas, your report is ...