Skip to main content
This widget is a dynamic tool for interactively exploring, organizing, filtering, and summarizing KPIs across datasets. To access this tool, click Pivot Table under the Tools section on the left-side panel.
The SIMCEL left-side navigation panel with the Tools section expanded and Pivot Table highlighted

Opening the Pivot Table from the Tools section of the left-side panel

​
Key features

​
Dynamic data selection

You can choose datasets and time periods (for example Actuals, Budgets, Plans) to populate the pivot table.
Pivot Table dataset and time period selectors at the top of the table, used to choose which data populates the view

Selecting datasets and time periods to populate the pivot table

​
Customizable rows and columns

To access the Field List, click the Fields button on the right-side panel of the table.
The right-side panel of the Pivot Table showing the Fields button used to open the Field List

The Fields button on the right-side panel of the table

Select and drag-and-drop fields to arrange them dynamically as rows and columns.
The Field List showing available fields being dragged into the rows and columns areas to arrange the pivot table layout

Dragging fields into the rows and columns areas of the Field List

You can open the Field List settings to customize the visualization.
The Field List settings panel open over the Pivot Table, showing the configured row, column, and value fields

The Field List settings used to customize the pivot table visualization

​
Summarization options

The Pivot Table provides summary functions such as Sum, Average, Count, and Max/Min for numerical data.
The summary function menu next to a value field, listing Sum, Average, Count, Max, and Min options

Choosing a summary function for a value field

You can find the summary functions right next to each value field, directly in the Field List settings.

​
Multi-level grouping

The Pivot Table supports hierarchical grouping (for example Channel > Sub Channel) by dragging and dropping fields within the Field List settings.
Pivot Table with multi-level grouping applied, showing Sub Channel totals nested beneath each Channel

A hierarchical grouping of Channel and Sub Channel in the pivot table

​
Filtering and sorting

To access the filters, click the Filters button on the right-side panel of the table.
The right-side panel of the Pivot Table showing the Filters button

The Filters button on the right-side panel of the table

You can filter every field, such as the dataset and the columns, by value or alphabetical order.
The filter panel for a Pivot Table field, with options to filter the values by value or in alphabetical order

Filtering a field by value or alphabetical order

You can reach the sort feature through the sorting icon right next to each field, directly in the pivot table.
A Pivot Table field header with its sorting icon, used to sort the field ascending or descending

The sorting icon next to a field header in the pivot table

​
Drill-down capability

You can expand summary values to view the detailed underlying data. The drill-down function becomes accessible when there are at least 3 grouping fields.
Pivot Table with a summary row expanded to show the detailed underlying records beneath it

Expanding a summary value to reveal the detailed underlying data

​
Save and load configurations

You can save customized pivot table configurations for reuse.

​
Dimensions available

​
Use cases

  • Profitability by customer channel - Put Customer Channel on rows, profit KPIs as values
  • Demand by brand over time - Put Brand on rows, Time on columns, Demand Value as the value
  • Cost breakdown by facility - Put Location on rows, cost KPIs as values
  • Scenario comparison - Put Scenario on columns to compare all KPIs across planning scenarios