Hello,
in 2K5 the Rank function shows reversed results.
Is there an mistake in this query?

Thank you for reading this
Jörg


With Member Measures.ProdRank as
Rank(
[Product Categories].CurrentMember
,{[Product Name].Members}
,[Internet Sales amount]
)
select
measures.ProdRank on 0
,TopCount([Product Name].Members,10,[internet sales amount]) on 1
from [adventure works]

Returns
ProdRank
Road-150 Red, 48 397
Road-150 Red, 62 396
Road-150 Red, 52 395
Road-150 Red, 56 394
Road-150 Red, 44 393
Mountain-200 Black, 42 392
Mountain-200 Silver, 38 391
Mountain-200 Black, 46 390
Mountain-200 Black, 38 389
Mountain-200 Silver, 46 388

I believe this was a bug in RTM -- it should be fixed in SP1...

Thanks,
Akshai

--
--
This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Joerg" <Joerg (AT) discussions (DOT) microsoft.com> wrote