When Rank Fn is used in Dimensional Reporting Sorting Doesnt Work

[cognos05]

Hi ,

I have a simple Cross tab  with Accounts in row and I have some products in Column ,Now I have to find the rank of Accounts for each product based on its penetration.
RankMeasure     Prd1    Prd2     Prd3
           A1             2           1          2
           A2             1           2         1

SO the Calculation I used in my measure is

rank( [Sales]/[Population] within set [Accounts])
[Population] = CompleteTuple([2015],Currentmember([Account Hierarchy]))     - its the population for the respective Accounts.

so everything looks fine except I am unable to sort my Accounts based on a Product Ranked.

I tried removing rank and did sorting and it worked.
You can replicate the same with rank([Sales]/Revenue] within set [Accounts] ) on the measure and sort will not work.


I tried using order ([Accounts],[Product],BDesc) but didnot work.

Any help is appreciated .

Thanks,
Nithya