You can configure pivot tables in Reporting to show 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 show the data in one row for each employee.
When you open a report that has a pivot table configured, the report designer shows 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 Filters and Relationships buttons aren't enabled when you’re in the Pivot table tab.