Why does my PivotTable not pick up all the column headings from payroll? #
This is likely due to not selecting all the data columns; for example, if you have added some pay definitions since you first created the report or are using more Shift Pay Items, the number of columns in the underlying data will increase.
In Excel:
- Click anywhere in the PivotTable
- Menu Pivot Table Analyse > Change Data Source and carefully modify the Location to include the last column of data:
Analytics checklist for missing data in a PivotTable #
- Have you run Analytics and included the full date range needed?
- Check and Note the last Excel column of data in the analytics file above.
- Then click in the pivot table, if you go to Pivot Table Analyse > Change data source, does it include columns up to the last column?
- Have you done a Data > Refresh all in Excel
- Have you checked that all Excel PivotTable filters do not hide any needed data?