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