CompareOrderedMembersBy 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.  

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.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.