Adding Fields to an existing Spreadsheet and viewing them in the Pivot Table This example will show how to use your own calculated fields in a spreadsheet and then be able to view that information in the pivot table. We will use the Budget with ...
Use this cheat sheet for quick how-to information on pivot tables. Information includes dragging and dropping fields on and off the report, adding additional fields, creating new calculated fields, sorting, filtering, adding page breaks and more!
To save pivot table data to a new spreadsheets: Right click on the tab for the pivot table. Select Move or Copy Select New Book Check “Create a Copy" Click on OK The pivot table data is now in a new sheet – you can save it as any name. Note – this ...