CompareMemberCaptionsBy Property

PivotMembersCompareByEnum

PivotMembersCompareByEnum can be one of these PivotMembersCompareByEnum constants.
plMembersCompareByName Captions are compared by name. Use this setting if you want each occurrence of a particular caption to be renamed according to the corresponding setting established by the MemberCaptions property. This is most useful with dates and times. For example, you may want to replace each instance of February with Feb.
plMembersCompareByUniqueName Captions are compared by their unique name. Use this setting when the data set contains multiple instances of a caption that are unrelated to each other. For example, the data set may contain an item named Portland under Maine and Oregon, but you do not want both of these instances to share the same caption.

expression.CompareMemberCaptionsBy

*expression   * Required. An expression that returns a PivotFieldSet object.

Remarks

The default setting when the specified field set is a time-based field is plMembersCompareByName. Otherwise, the default setting is plMembersCompareByUniqueName.

Applies to | PivotFieldSet Object

See Also | MemberCaptions Property