Pivot the Billboard Data

You can pivot data to transform columns into rows and rows into columns, or to summarise the data. For example, the following table displays data from a SQL query.

Stockpile	Product	Tonnes	Analyte	Value
Stockpile 1	Product A	100938	Analyte A	156.2
Stockpile 1	Product A	100938	Analyte B	4.3
Stockpile 1	Product A	1009938	Analyte C	6800
Stockpile 2	Product B	267700	Analyte A	160.8
Stockpile 2	Product B	267700	Analyte B	5.2
Stockpile 2	Product B	267700	Analyte C	6904

If the Pivot Column is Analyte and the Pivot Value is Value, the billboard displays this pivoted data.

Stockpile	Product	Tonnes	Analyte A	Analyte B	Analyte C
Stockpile 1	Product A	100938	156.2	4.3	6800
Stockpile 2	Product B	267700	160.8	5.2	6904

Security Note: You need the Allow billboard maintenance security right in the Billboards domain security rights group for this activity.

Activity Steps

1. Open the Billboard (configuration).
2. Select the Configuration tab.
3. Check Pivot Data.
4. Select the Pivot Column and Pivot Value.
5. Click Save.