Pivot Data

The

Simple Pivot action allows you to ?aggregate calcs based on distinct values of one field and group by another ? flattened to simple records

You could use the

Group action to get subtotals by region for each item. The results would have one record for each unique item-region combination. If you group on the item field and subgroup by region the results look something like this:

Pick a record table to pivot data

The repeating record that identifies the table of data to pivot. This defaults to the first repeating record in the results you have connected as input to this block.

Click in this field to select a different repeating record. See Select Fields or Paths for Block Properties with the Path Selector for more information.

Pick a field to group records on

Click in this field to select the field for the top level grouping of this pivot table. See Select Fields or Paths for Block Properties with the Path Selector for more information.

The unique values for this field are used to group records from the results.

Pick a field to generate column headers

Click in this field to select the field for the second level of grouping for this pivot table. See Select Fields or Paths for Block Properties with the Path Selector for more information.

Each unique value of this field adds a column to the result records for this block with the aggregate calculation for that subgroup. The new column name is the corresponding unique value.

Note:

Actual column names may not match the unique values exactly because they must meet XML name standards. Wires automatically alters column names to meet this requirement.

Pick a field to aggregate values for specified group & column

Click in this field to select the numeric result field to use in aggregate calculations for the selected subgroup. See Select Fields or Paths for Block Properties with the Path Selector for more information.

How would you want to aggregate values?

Select the aggregate function you want to apply to subgroups from the list:

Average

Count

Maximum

Minimum

Sum

Or use the Path Selector to supply the function name dynamically. See Select Fields or Paths for Block Properties with the Path Selector for more information.