FindColumnMember Property

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.  

Finds a column member, given a reference to the member. Returns a PivotColumnMember object.

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.

PivotMemberFindFormatEnum

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.