Cant sort by calculated measure

[ttgchicago]

Alex -

Sorry for all the questions today.

I added a calculated measure to my cube and the sort button in the grids doesnt seem to work with it. For example, Add the following CM to the demo (0-15 / Net AR)

Result = (("01 - 15"[VALUE] / "Net AR"[VALUE]) * 100)

Then return to the grid. The sort for the new measure is doing something (?), but not what Im expecting?!?

Any ideas?

[AlexZencovich]

Bob, I have no such measures in demo. But I test with another measures (Summa,Count,Quantity) and forumal like you show - and it works as expected. May be you need to send me example of your cube?