Making ranking COLUMN in Excel for data from OLAP cube -
04-10-2005
, 02:44 PM
Helo,
I have a problem. My customers uses Excel XP for OLAP cube browsing . In
Excel he sorts results in ROWS, so in ROWS he receives result ranked by one
measure. But also he needs the RANK column for each row (for example best
selling product, represented in first row receives 1, second product -2 and
so on).
Product Rank Value
Apples 1 120
Grapes 2 115
Oranges 3 95
Is any possibility to add new RANK measure (for example using calculated
member)?
Ernestas |