{"id":2692,"date":"2015-03-23T19:06:28","date_gmt":"2015-03-23T11:06:28","guid":{"rendered":"http:\/\/localhost\/help\/?page_id=2692"},"modified":"2017-12-14T14:37:26","modified_gmt":"2017-12-14T06:37:26","slug":"pivot-table-4-3-2","status":"publish","type":"page","link":"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/controls\/pivot-table\/pivot-table-4-3-2\/","title":{"rendered":"Pivot Table (4.3.2)"},"content":{"rendered":"

<\/p>\n

This article applies to versions 4.3.2 and earlier of P2 Explorer. For help on the latest version of the pivot table, see Pivot Table<\/a>.<\/p>\n

Overview<\/h3>\n

The Pivot Table allows users to automatically sum the data stored in a dataset, and display the results in a table with specified rows and columns. The Pivot Table component can be displayed on a page\u00a0as a preconfigured table, or it can allow the user to change the pivot points to analyse\u00a0different aspects of the source data.\u00a0<\/p>\n

The following diagram shows a\u00a0Pivot Table being configured:<\/p>\n

\"pivot\"<\/a><\/p>\n\n\n\n\n\n\n\n
Source Data<\/strong>:<\/td>\nThe dataset from which the pivot table sources its data.<\/td>\n<\/tr>\n
Columns<\/strong>:<\/td>\nThe columns of the dataset that appear as columns\u00a0in the pivot table.\u00a0<\/td>\n<\/tr>\n
Rows<\/strong>:<\/td>\nThe columns of the dataset that appear as rows in the pivot table.<\/td>\n<\/tr>\n
Values<\/strong><\/td>\nThe columns of the dataset\u00a0that\u00a0the pivot table will analyse. \u00a0Not all columns\u00a0will be suitable to add to this area; you would typically only add those columns\u00a0with numerical values, such as downtime hours.<\/td>\n<\/tr>\n
Hide Config Panel<\/strong><\/td>\nSelect this check box if you do not want the configuration panel to be visible to the user. This will result in just the table being displayed on the page, and the user will be unable to change the pivot points.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u00a0<\/p>\n

\n

Tutorial<\/h3>\n
\n

The Pivot Table\u00a0is a useful component that enables users to view and analyse tabular data in different ways.<\/p>\n

In this tutorial, we\u2019ll look at adding a Pivot Table\u00a0that will change what is displayed as the user selects different times.<\/p>\n

\"downtimepivot\"<\/a><\/p>\n

Let\u2019s go through this process, step-by-step.<\/p>\n

\n

Step by Step: Creating a Pivot Table Driven by a Range Picker and Entity Selector<\/span><\/h3>\n

Before you start, open a new tab in Explorer and click the \u201cCreate a New Page in Studio Mode\u201d thumbnail. Choose the grid<\/a>\u00a0layout \u2013 you can adjust the rows and columns if you like but it\u2019s not important for this exercise.<\/p>\n

You will need to adjust the configuration to suit your data at your site.<\/p>\n

Step 1. Add the\u00a0source data<\/strong><\/p>\n

\"pivotdata\"<\/a><\/p>\n

As Pivot Tables are designed to display data, the first thing we want to do is add\u00a0the data<\/a> we want to display.<\/p>\n