This will convert the PivotTable report to a formula- based report that is still tied to the original data source, as suggested in the screenshots below. This is done by checking the box next to Add this data to the Data Model when creating a PivotTable, as circled in the screenshot below. For this functionality to work, you must add the PivotTable report to the Data Model when you create the PivotTable. Once converted to formulas, your report is no longer bound by the confines of the PivotTable structure, and you are free to edit the report as desired. 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. In some cases, CPAs find they want to further refine their PivotTable reports using Excel's full complement of editing tools, but their hands are tied by the PivotTable structure.
However, once your desired PivotTable is created, you are correct in that your editing options become somewhat restricted. Two key advantages of Excel's PivotTables are that they are easy to create and they provide a structure that can be pivoted to reveal a multitude of report layouts. I usually like Excel PivotTables, but because they don't allow me to do certain things, such as delete cells or insert new columns or rows, I'm wondering if there is a reasonable alternative?Ī.
0 kommentar(er)
