Data pivot

The Data Pivot function is used to reorganize your data by turning rows into columns or columns into rows. This makes the data easier to view, compare, and analyze.

It’s especially helpful when you want to:

• Group data by specific categories
• Summarize values (like totals or counts)
• Compare information side by side in a more meaningful format

Example:

If your data has rows like this:

Pivoting it by Sales Type would turn it into:

How to use Data Pivot?

Step 1: Join the Data Pivot component to the step.

Step 2: Open the Data Pivot component and fetch the columns.

Step 3: In the “Group” field, specify the columns the user wants to group.

Step 4: In the “Pivot Column Field,” select columns other than those that have been grouped. This choice determines how the pivoted data will be displayed with that specific information.

Step 5: In the “Value Field,” the numeric field’s values will be calculated and shown in the pivot table. By enabling “Advance options,” the user can select the aggregation function.

Click “Save” to proceed.

For example:

• In the “Group” field, we opted for “Channel” for grouping.
• For the “Pivot Column Field,” we selected “Ship_mode.”
• In the “Value Field”, we selected “Sales” to represent the data in the “Pivot Column Field” and applied the “Average” as the “aggregation function.”

Preview