GRW Reference / Pivot table library |
Three types are defined for the pivot library: pivotHierarchy, pivotMeasure, and pivotPivotTable.
PUBLIC TYPE pivotHierarchy RECORD name STRING, title STRING, format STRING, value STRING, isNumeric STRING, enumValues STRING, computeTotal STRING, computeCount STRING, computeDistinctCount STRING, computeAverage STRING, computeMinimum STRING, computeMaximum STRING END RECORD PUBLIC TYPE pivotMeasure RECORD name STRING, title STRING, format STRING, value STRING, isNumeric STRING END RECORD PUBLIC TYPE pivotPivotTable RECORD name STRING, #PIVOTTABLE title STRING, #PIVOTTABLE drawAs STRING, #PIVOTTABLE computeAggregatesOnInnermostDimension STRING, #PIVOTTABLE displayRecurringValues STRING, #PIVOTTABLE hierarchiesDisplaySelection STRING, #PIVOTTABLE inputOrder STRING, #PIVOTTABLE displayFactRows STRING, #FACT measuresDisplaySelection STRING, #FACT outputOrder STRING, #FACT topN INTEGER, #FACT hierarchies DYNAMIC ARRAY OF pivotHierarchy, measures DYNAMIC ARRAY OF pivotMeasure END RECORD