All About Pivot
Overview
Flip data across it's diagonal; in other words, switch column headers into rows.
1. Add Pivot in Your Dataflow
2. Pivot Options
1. Add pivot in Your Dataflow
Add Pivot to any node in your Dataflow. Select any node and use the Transform (+) button to open the list of options to select Pivot. You could work with the node in the Dataflow tab or use the Properties panel.
2. Pivot Options
Pivot node has three fields to flip and summarize data. Read along to see how we pivot and summarize the follow sales data.
2.1 Select Rows
The first option lets you choose which data field will become the rows in your new data.
Note: You may add more than one.
2.2 Select Columns
The second option lets you choose which data fields will become the columns in your new data.
Note: You may add more than one.
2.2 Select Values
The third option lets you determine the value that will be represented in the new columns.
Note: You may add more than one.
Here's what the sales data looks like after pivoting by Segment and Country, and showing the Profit for each.
Related articles
Next steps
Other Topics
