You can configure pivot tables in Reporting to display data in reports in a flattened format. For example, the Earnings and Hours by Range report displays multiple rows for each employee, with each earning record on a separate row. Using a pivot table, you can display the data in one row for each employee. In the example below, each row displays aggregated amounts for each earning type for each date range:
The column headings in the pivot table explain which data is included and which aggregation operation has been applied. The information is displayed in the heading in the following format: Pivot Column Value_Value_Aggregate Function. For example, the header for the first column in the screenshot above is Regular_Date Range Earnings_Sum. This shows that the column displays the sum of date range earnings with the "Regular" earning code. This column is included in the pivot because "Record Code" was selected as the pivot column value, and Date Range Earnings was configured as one of the pivot values with the "sum" aggregate. The date range is selected in the filters of the report.
Note: If the selected column data has any null values, they’re displayed as (blank) in the column header. For example, if there was a null value for record code in the example above, the column header is displayed as (blank)_Date Range Earnings_Sum. The (blank) is added so that you can see where a null value is represented.
When you open a report that has a pivot table configured, the report designer contains two tabs: Base report and Pivot table. The Base report tab contains all of the report designer functionality that is present when you’re editing a report without a pivot. In the Pivot table tab, the toolstrip buttons are enabled only for items that can be edited on the pivot table itself. For example, filters and relationships can be configured only on a base report and not on a pivot table, so the Filtering and Relationships buttons aren't enabled when you’re in the Pivot table tab.
For more information on working with pivot tables, see the following topics: