About the Pivot Tool
The Pivot Tool in Savant transforms and summarizes data by pivoting fields. It organizes data into a tabular format by grouping values, applying aggregations, and customizing how the data is displayed.
Configuration Options
Create and Name Pivoted Fields Using:
Select the field you want to pivot (e.g., Date, Region).
Populate the Fields with Values From:
Choose the field containing the data to be summarized (e.g., Sales_Amount).
Aggregate the Values Using:
Apply an aggregation function to the data. The available options depend on the data type.
Aggregation Functions
Numeric Fields
Aggregation | Description |
SUM | Calculates the total sum of numeric values. |
AVG | Computes the average of numeric values. |
MIN | Returns the smallest numeric value. |
MAX | Returns the largest numeric value. |
COUNT | Counts all rows, including duplicates. |
COUNT DISTINCT | Counts unique values only. |
STDDEV | Calculates the standard deviation of values. |
VAR | Computes the variance of numeric values. |
MEDIAN | Returns the middle value in an ordered set. |
ANY | Returns any non-null value from the dataset. |
Text Fields
Aggregation | Description |
COUNT | Counts all rows, including duplicates. |
COUNT DISTINCT | Counts only unique values. |
ANY | Returns any non-null value from the dataset. |