Skip to Content
Aug 12, 2014 at 01:42 PM

Sorting dimension member based on two properties



I am using SP BPC NW 10.0 SP04 (801).

I have a query regarding sorting dimension member based on two properties. In Report Editor under Sorting and Grouping tab there is option for grouping based on single propery only.

I have taken Profitcenter in Row axis. There are two properties TYPE and SEGMENT I have taken along with it as local member. A SEGMENT can have multiple TYPE(defined in TYPE property). I have sorted SEGMENT using Report Editor Sorting and Grouping. Now I want to sort TYPE of a segment also.

Same thing is possible in MS version with SortCol1, SortCol2 etc.. How this can be possible in NW version. Can anyone help in this.

Thanks & Regards,

Deepak Palsaniya