EPM sorting within a grouping by Property

[Former Member]

Hello, I have a member grouping plus a sorting within a group requirement.

I have COSTCTR dimension and it has a property called PROFIT_CENTER on it. I need a report. There is no profitcenter dimension in the model.

I need a report with costcenter in the rows and profitcenter (local member) grouped/sorted by PROFIT_CENTER property and within each grouping of the profit center the costcenters should be sorted in ascending order. Is this even possible.?

Thanks,

Bobby

[former_member186338 · Accepted solution]

You can sort by single property of dimension using member sorting. But then - no way to sort by COSTCTR id!

[Former Member]

Thanks Vadim, That's what I thought too. Just want to check with the expertsbefore giving up.