constant that determines how the PivotTable control compares member captions to the list of custom captions set by the MemberCaptions property. Captions that match the custom list established by the MemberCaptions property are renamed using the custom caption. Read/write.
| 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.