2.2.5.1 PivotTable Records

For general information about records see section 2.1. PivotTable (section 2.2.5) uses records from the Worksheet Substream (section 2.1.7.20.5), the Globals Substream (section 2.1.7.20.3), and the streams in the Pivot Cache Storage (_SX_DB_CUR) (section 2.1.7.12).

Concepts specified for PivotTables can have multiple sequences of records specifying them. The sequences can be in different streams or substreams. In these cases additional information is specified for the concept in the PIVOTFRT9 rule (section 2.1.7.20.5) or by SXAddl records (section 2.4.273.2). See the individual records, the QsiSXTag record (section 2.4.211) and section 2.2.5.1.1 for more information about how the additional information is connected to the concept.