Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Top N Rank BEx Query Issue

Hi All,

We have Top N ranking queries, and queries are ranked based on restricted key figures by setting an option Display values as "Rank Numbers". When we excute the query designer the ranks are repititive i.e. we can see more than 1 rank for different value. For Ex:

Plant Amount rank

ABC 110.34 1

CDE 109.84 1

EFG 110.00 1

GHI 100 2

IJK 99.58 2

KLM 99.85 2

and soon.

Key figure Amount is formula with two decimal places and rank is restricted key figure, if I convert rank to formula also same issue. Would any one faced this issue if yes, please help me out in resoving this issue. I apprecaite by assigning points.

Thanks

Eric

Former Member
Not what you were looking for? View more on this topic or Ask a question