Types defined in the pivot 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