0 / 0
Example of vertically pivoting data

Example of vertically pivoting data

In this example, the Pivot Enterprise stage is set up to vertically pivot some data and aggregate a monthly average of sales.

The following tables provide examples of data before and after a vertical pivot operation.
Table 1. Input data for vertical pivot operation
REPID last_name Q_sales
100 Smith 1234.08
100 Smith 1456.80
100 Smith 1578.00
101 Yamada 1245.20
101 Yamada 1765.00
101 Yamada 1934.22
Table 2. Out put data for vertical pivot operation
REPID last_name Q_sales (January) Q_sales1 (February) Q_sales2 (March) Q_sales_average
100 Smith 1234.08 1456.80 1578.00 1412.96
101 Yamada 1245.20 1765.00 1934.22 1648.14

The following screen capture shows the settings for a vertical pivot set by clicking Edit on the Pivot Properties section of the Stage tab.

Figure 1. Example of vertical pivot settings on the Vertical pivot pageShows the settings for a Vertical pivot page configured to generate multiple columns containing the vertically pivoted data, and columns containing an aggregated sum and first value.

Generative AI search and answer
These answers are generated by a large language model in watsonx.ai based on content from the product documentation. Learn more