Chapter 12. Using the Pivot Table app

Table of Contents

12.1. About the Pivot table app
12.2. Create a pivot table
12.2.1. Select dimension items
12.2.2. Modify pivot table layout
12.3. Change the display of your pivot table
12.4. Manage favorites
12.4.1. Open a favorite
12.4.2. Save a favorite
12.4.3. Rename a favorite
12.4.4. Write an interpretation for a favorite
12.4.5. Create a link to a favorite
12.4.6. Delete a favorite
12.4.7. View and comment interpretations
12.5. Download data from a pivot table
12.5.1. Download table layout data format
12.5.2. Download plain data source format
12.5.3. Download a CSV format without rendering data in the web browser
12.6. Embed a pivot table in an external web page
12.7. Visualize a pivot table data as a chart or a map
12.7.1. Open a pivot table as a chart
12.7.2. Open a pivot table selection as a chart
12.7.3. Open a pivot table as a map
12.7.4. Open a pivot table selection as a map
12.8. Constraints and tips

12.1. About the Pivot table app

With the Pivot Table app, you can create pivot tables based on all available data dimensions in DHIS2. A pivot table is a dynamic tool for data analysis which lets you summarize and arrange data according to its dimensions. Examples of data dimensions in DHIS2 are:

  • data dimension itself (for example data elements, indicators and events)

  • periods (representing the time period for which the data represents)

  • organisation hierarchy (representing the geographical location of the data)

From these dimensions you can freely select dimension items to include in the pivot table. You can create additional dimensions in DHIS2 with the group set functionality. This allows for different aggregation pathways, such as aggregation by "Partner" or facility type.

A pivot table can arrange data dimensions on columns, rows, and as filters. When you place a data dimension on columns, the pivot table will display one column per dimension item. If you place multiple data dimensions on columns, the pivot table displays one column for all combinations of the items in the selected dimensions. When you place a data dimension on rows, the pivot table displays one row per dimension item in a similar fashion. The dimensions you select as filters will not be included in the pivot table, but will aggregate and filter the table data based on the selected filter items.