Export (0) Print
Expand All
Expand Minimize

2.5.257 SxIvdCol

Office

The SxIvdCol structure specifies a reference to a pivot field or data field on the column axis


0

1

2

3

4

5

6

7

8

9
1
0

1

2

3

4

5

6

7

8

9
2
0

1

2

3

4

5

6

7

8

9
3
0

1

col

col (2 bytes): A signed integer that specifies a pivot field or data field for the column axis of the PivotTable view. MUST be a value from the following table:

Value

Meaning

-2

This value specifies that the data field is on the column axis. The sxaxisCol field of sxaxis4Data of the SxView record of the PivotTable view MUST equal 1 and the sxaxisData field of sxaxis4Data of the SxView record of the PivotTable view MUST equal zero.

0+

This value specifies a pivot field index as specified in Pivot Fields. The pivot field index specifies a pivot field on the column axis of the PivotTable view. MUST be less than the cDim field of the SxView record of the PivotTable view. If the referenced pivot field is not a hidden field in an OLAP PivotTable view then the sxaxisCol field of SXAxis of the Sxvd record of the pivot field MUST equal 1.

A pivot field is a hidden field if an SXAddl_SXCField12_SXDVer12Info record exists for the pivot field, and the fHiddenLvl field of the SXAddl_SXCField12_SXDVer12Info record is 1.

Show:
© 2014 Microsoft