constant that determines how the PivotTable control sorts members of the specified field set when a custom sort order has been established by the OrderedMembers property. 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.CompareOrderedMembersBy
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.