If you’ve created a pivot table and later added more data then you’ll need to expand the pivot’s data range.
NOTE: You can change your data into an Excel Table (Hold ‘Ctrl’ key and press ‘T’) and when you add more data the Pivot range won’t require expanding (just refresh the Pivot)
Download my Excel file
Download here or via my OneDrive (file 00014)
Watch my YouTube video