We have added search box. Key in SAP issue keyword to search
TopBottom

Announcement: wanna exchange links? contact me at sapchatroom@gmail.com.

[sap-bw] Ranking Irrespective of Filter SAP BEx

Posted by Admin at
Share this post:
Ma.gnolia DiggIt! Del.icio.us Yahoo Furl Technorati Reddit

Question from Neha_Tank on Dec 8 at 2:00 AM
Hello all,

It there any way we can generate the rank for a field in the BEx?
Reports with respect to the whole data loaded in the BW. I have one value
key figure and for that I need to generate the rank on the whole data.

Let this be the whole data in BW

eg : VALUE key#
50000 1001
60000 1002
70000 1003
80000 1004
10 2001
3 2002
11 2003

suppose I run the report for the the key value 100*


The the output should be as shown below, the rank field should be generated
dynamically based on the whole

data in BW
VALUE Rank key#
50000 4 1001
60000 3 1002
70000 2 1003
80000 1 1004
 
Reply to this email to post your response.
 
__.____._
Manage Settings | Unsubscribe | Create FAQ | Send Feedback
  
© 2016 Ziff Davis, LLC. and message author.
Ziff Davis, LLC. 28 E 28th Street New York, NY 10016
Neha_Tank  
 
View this online
Ask a new question
 
In the Spotlight
Earn Recognition for Your Contributions at Toolbox for IT. Gain Points for Community Achievements

_.____.__

0 comments:

Post a Comment

T r a n s l a t e to your language