Safe Haskell | None |
---|---|
Language | Haskell2010 |
- data PivotTable = PivotTable {
- _pvtName :: Text
- _pvtDataCaption :: Text
- _pvtRowFields :: [PositionedField]
- _pvtColumnFields :: [PositionedField]
- _pvtDataFields :: [DataField]
- _pvtFields :: [PivotFieldInfo]
- _pvtRowGrandTotals :: Bool
- _pvtColumnGrandTotals :: Bool
- _pvtOutline :: Bool
- _pvtOutlineData :: Bool
- _pvtLocation :: CellRef
- _pvtSrcSheet :: Text
- _pvtSrcRef :: Range
- newtype PivotFieldName = PivotFieldName Text
- data PivotFieldInfo = PivotFieldInfo {}
- data PositionedField
- data DataField = DataField {}
- data ConsolidateFunction
Documentation
data PivotTable Source #
PivotTable | |
|
newtype PivotFieldName Source #
data PivotFieldInfo Source #
data PositionedField Source #
data ConsolidateFunction Source #
Data consolidation functions specified by the user and used to consolidate ranges of data
See 18.18.17 "ST_DataConsolidateFunction (Data Consolidation Functions)" (p. 2447)
ConsolidateAverage | The average of the values. |
ConsolidateCount | The number of data values. The Count consolidation function works the same as the COUNTA worksheet function. |
ConsolidateCountNums | The number of data values that are numbers. The Count Nums consolidation function works the same as the COUNT worksheet function. |
ConsolidateMaximum | The largest value. |
ConsolidateMinimum | The smallest value. |
ConsolidateProduct | The product of the values. |
ConsolidateStdDev | An estimate of the standard deviation of a population, where the sample is a subset of the entire population. |
ConsolidateStdDevP | The standard deviation of a population, where the population is all of the data to be summarized. |
ConsolidateSum | The sum of the values. |
ConsolidateVariance | An estimate of the variance of a population, where the sample is a subset of the entire population. |
ConsolidateVarP | The variance of a population, where the population is all of the data to be summarized. |