Pivot Table Field

The Pivot Table Field activity is used to add a field from the source data to an existing pivot table. This activity must be used inside the Create Pivot Table activity.

Limitations of Pivot Table Field

a. The Add Pivot Table Field activity is supported only within the Create Pivot Table activity.
b. Multiple pivot table fields can be added within a pivot table.
c. No other activities can be placed inside the Add Pivot Table Field activity.
d. While it can be added to the workflow designer, it cannot be executed independently or used outside the Create Pivot Table activity.

Properties

Field Name: Specifies the field from the source data to be added to the pivot table.

Is a: Defines how the field to be added. Options include:
Row – Adds the field as a row item.
Column – Adds the field as a column item.
Filter – Adds the field as a filter.
Value – Adds the field as a value field, which requires selecting an aggregation function.

Function: Specifies the aggregation function when the field is added as a value.

Available functions include:

1. SUM: Adds all numeric values to give the total.
2. AVERAGE: Returns the “mean” of numeric values.
3. COUNT: Counts cells containing numeric values only.
4.COUNT NUMBERS: Counts how many rows contain numbers (ignores text/blanks).
5. MAX: Returns the highest numeric value.
6. MIN: Returns the lowest numeric value.
7. PRODUCT: Multiplies all numeric values together.
8. VAR: Calculates the difference between values when using a sample of the data.
      Example: Calculates variation in sales from selected stores.
9. VAR P: Calculates the difference between values when using all the data.
      Example: Calculates variation in sales across all stores.
10. STDDEV: Calculates the typical distance of values from the average in a sample.
     Example: Calculates how much selected employees’ salaries differ from the average.
11. STDDEVP: Calculates the typical distance of values from the average in the full dataset.
      Example: Calculates how much all-employees’ salaries differ from the average.