expression.FindColumnMember(Path, Format)
expression Required. An expression that returns a a PivotColumnMember object.
Path Required String. A variable or string that contains a reference to the member to find.
Format Required PivotMemberFindFormatEnum . Indicates the format used for the Path argument.
| PivotMemberFindFormatEnum can be one of these PivotMemberFindFormatEnum constants. |
| plFindFormatMember Not supported for this property. |
| plFindFormatPathHex Not supported for this property. |
| plFindFormatPathInt Member reference is a path of indexes. For example, "1\0\5\1". |
| plFindFormatPathName Member reference is a unique name, or can be a name if unambiguous. For example, "[USA].[Oregon].[Portland]". |
Remarks
If the requested member is not found, a PivotColumnMember object with the IsValid property set to False is returned. This allows you to refer to a member that might later be added to the schema.
This property can be used to find a member from the top member of the column axis. Use the Member property to return the top member of the column axis.