How to create multiple years of data in Budget Details
Highlight data. (Hint: click in first cell, hold Shift key down, press END and Right arrow key to highlight to the end of the first row. Repeat with Shift, END and down arrow key to highlight to bottom of spreadsheet..
Now you can click on your Budget Details Pivot Table tab and click on Refresh Data button to update the information in the Pivot Table with Multiple year data.
Right click in the pivot table and select “Show Field List”. Scroll to the bottom and you will see Year listed.
Left-click on Year and drag to the left of the Date in the Pivot Table area if you wish to separate year information.
Budget Pivot Table
The Year column created on the Budget Details tab is now available in the Field List