dbTalk Databases Forums  

Making ranking COLUMN in Excel for data from OLAP cube

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Making ranking COLUMN in Excel for data from OLAP cube in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Ernestas
 
Posts: n/a

Default 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



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.