Using pivot tables instead of spreadsheets

Pivot tables are tables on "steroids" that can display data in a grid layout with unlimited layers of row header cells and column header cells that are hierarchically nested. Also, they can have a drilling down functionality to drill down on different groups. Similar to spreadsheets, pivot tables provide options to automatically generate subtotals and totals for the grouped data.

In this recipe, we will use the PivotTable and pivotFilterBar components to display and filter the number of employees by drilling into different regions, countries, cities, and departments with totals and subtotals. We will also get to know about a new layout component, panelSplitter.

In this recipe, the model has been created for you; you can continue from the previous recipe or you can open the project directly by cloning the PivotTable project from the Git repository.

How to do it...

In order to add a pivot table, follow the ensuing steps:

1. Create a new task flow inside the...