This record contains PivotTable view fields and other information.
Record Data
Offset |
Name |
Size |
Contents |
4 |
sxaxis |
2 |
Axis: |
6 |
cSub |
2 |
Number of subtotals attached. |
8 |
grbitSub |
2 |
Item subtotal type (see the following table). |
10 |
cItm |
2 |
Number of items. |
12 |
cchName |
2 |
Length of the name; if the name = FFFFh, rgch is null and the name in the cache is used. |
14 |
rgch |
var |
Name. |
The subtotal type (grbitSub) bits are defined as shown in the following table.
Name |
Contents | |
bitFNone |
0000h | |
bitFDefault |
0001h | |
bitFSum |
0002h | |
bitFCounta |
0004h | |
bitFAverage |
0008h | |
bitFMax |
0010h | |
bitFMin |
0020h |
Name |
Contents | |
bitFProduct |
0040h | |
bitFCount |
0080h | |
bitFStdev |
0100h | |
bitFStdevp |
0200h | |
bitFVar |
0400h | |
bitFVarp |
0800h |