When you run a report that has a pivot table configured, you can generate the base report or the pivot table. Users can select which option they want to generate when they run the report.
To generate a pivot table:
- Go to Reporting and Analytics > Reporting > Reports and open the report that has the pivot table that you want to generate.
- Click Run.
- If the report has filters, select the filter values.
- In the Report Type drop-down list, select Pivot table.
- Set the other report output and format options. See Run Ad Hoc Reports.
- Click Run Report.
After you click Run Report, Dayforce generates the pivot table and delivers it to your Message Center inbox.
Depending on the column and values fields that are configured in the pivot options, the pivot output sometimes generates a very large number of columns. This can result in problems with how the columns are displayed, especially if you’re generating the report in PDF file format. To avoid this, pivot tables are limited to a maximum of 100 columns for both PDF and Excel output formats. If your pivot table exceeds the maximum, an error message is displayed in the output file instead of the data. You can reduce the number of columns generated in a pivot table by adding a filter on the field that is configured as the column for the pivot.