How to create a Syntech Pivot table in Creatio
Step-by-step setup from an empty component to a table, chart, and record drill-down
Key steps
Follow these stages to build a pivot table with Syntech Pivot for Creatio, starting with an empty component and continuing through data selection, grouping, aggregation, and presentation. The guide also covers the toolbar actions and the drill-down that connects a table cell to its underlying records.
1. Add the component and connect the data
- Find Pivot Table under widgets and drag it onto the Creatio page. This places the component that you will configure, beginning the process of turning an empty pivot into a working table.
- Give the component an element code, such as pivot_order_data. The video describes the code in terms of the component name, the schema, and a name of your choosing. Save the page before moving on to the pivot configuration.
- Open the configuration using the gear icon in the toolbar. This is where you move from placing the component on the page to defining the data, grouping, and calculations that will appear in the pivot table.
- Use Data Sources to establish the primary object and add related objects alongside it. The walkthrough includes connecting a related object as a data source. This stage determines the source of the fields you will use to build the table.
2. Select fields and build the grouping
- Review Available Fields, which lists every column on the selected schema. Filter the list by type, such as text, number, date, or lookup, to focus on the kind of field you want to add to the pivot.
- Add a field to Rows with a click; the article's example uses State as a row field. Rows form part of the grouping, so this choice establishes how records are grouped along that side of the table.
- Add a field to Columns when you want grouping across the table as well as down its rows. Rows and columns work together to group and cross-tab the records. The video describes slicing data by dimensions such as status or month.
- Add more than one field to Rows or Columns to create a hierarchy. The first field becomes the parent level, and the remaining fields nest underneath it. Expand a level with a click to see the nested grouping rather than only its parent.
3. Define values and calculations
- Send a field to Values to define what the pivot will aggregate. The article uses Contract as its example value field. This separates the field being calculated from the row and column fields that organize the records into groups.
- Choose the aggregation for the value field: Sum, Count, Average, Min, Max, or Unique. Values is where the table's calculations are defined, so select the operation that corresponds to the number you want the grouped records to produce.
- Keep in mind that each value field has one aggregation, and change that aggregation when needed. For example, Sum and Count are both available choices. Revisiting this setting lets you change the calculation without treating the grouping fields as the place where the math is defined.
- Use a virtual column if the built-in fields do not provide the calculation you need. Write a formula directly, such as multiplying two fields together or wrapping a condition around a field. The resulting virtual column fits into the pivot like any other column.
4. Refine the table and view it as a chart
- Review the quick settings for Show total row and Show total column. These settings are included in the article's walkthrough. Use them to choose whether those total elements appear as part of the table presentation.
- Review Hierarchy mode alongside the grouping you have created. When multiple fields form nested levels, use the toolbar's Expand or collapse all action to toggle every hierarchy level at once. This gives you an alternative to expanding individual levels with a click.
- Use Advanced filters and Sorting and formats below the main configuration areas for finer control. The article specifically includes sorting and date format among the quick settings. Review these controls after defining the fields and calculations so you can refine the table's presentation.
- Switch from table mode to chart mode to redraw the same data as a visual rather than a grid. The article identifies a Bar chart in the walkthrough. This changes the way you view the pivot data while keeping the chart tied to that same data.
5. Inspect records and use the toolbar actions
- Click a table cell to open its drill-down panel. The panel shows exactly which records rolled up into the selected number. Use this view to trace an aggregate back to the records behind it instead of stopping at the table's summary.
- From the drill-down, click a record to open it on its own page. This takes you from the grouped result to an underlying record. Together, the cell click and record click provide the path from a pivot number to the data that contributed to it.
- Use Refresh to pull fresh data into the pivot, and use Save to retain the configuration. These toolbar actions have different purposes: one refreshes the data, while the other saves the setup. Choose the action that matches whether you need updated records or a saved configuration.
- Use Export to send the whole table to Excel with its formatting intact. If you want to start over instead, use Reset, which clears everything back to a blank slate. Distinguish between exporting the finished table and clearing the setup before choosing either action.
Transcript
Every record aggregated, grouped, and cross-tabbed. Sum, count, or average. Slice by status, by month, by anything. With a click into any cell to see exactly which records built that number.
Dropping the component onto a page takes one drag. Find Pivot Table under widgets, place it, and give it an element code like pivot_order_data. The component name, the schema, and a name of your choosing. Save the page, and configuration lies behind the gear icon in the toolbar.
Data Sources pins the primary object and lets you add related ones alongside it. Available Fields lists every column on that schema, filterable by type: text, number, date, lookup, and one click sends any of them into rows, columns, or values.
Rows and columns build the grouping. Add more than one field to either, and the first becomes the parent level with the rest nesting underneath, expandable with a click.
Values is where the math happens. Sum, count, average, min, max, or unique. One aggregation per field, changeable anytime.
And if the built-in fields aren't enough, virtual columns let you write a formula directly. Multiply two fields together, or wrap a condition around one. And it slots into the pivot like any other column.
Two more tools round it out. Advanced filters and sorting and formats sit below the main areas for finer control.
And the toolbar itself carries the daily actions. Refresh pulls fresh data. Save locks in the configuration. Expand or collapse all toggles every hierarchy level at once. Export sends the whole table to Excel with the formatting intact, and reset clears everything back to a blank slate.
Once it's built, the table itself is where the answers live. Click any cell, and a drill-down panel opens showing exactly which records rolled up into that number. Click again and the record opens on its own page.
Switch from table to chart and the same data redraws as a visual instead of a grid. That's Pivot Table. Every number traced back to the records behind it.
A step-by-step guide to creating a Pivot table using Syntech Pivot for Creatio, from an empty component to a working table and chart.
What is shown, in order:
— adding the "Pivot Table" component to the Creatio page;
— connecting the data source — a related object;
— adding a field to rows (State) and a field to values (Contract) with an aggregation type (Sum / Count / Unique / Min. / Max. / Average);
— quick settings: Show total row, Show total column, Hierarchy mode, sorting and date format;
— switching from table mode to a chart (Bar chart);
— clicking a cell to drill down to the underlying records.
Available here
Comments & questions
Sign in or register to leave a comment or question.
Sign in / Register