Share via

FindColumnMember Property

  • Article

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.

Applies to | PivotColumnMember Object

See Also | Find Method | FindAxisMember Property | FindMember Property | FindPageMember Property | FindRowMember Property