Skip to Content
0
Former Member
Jun 13, 2013 at 05:54 AM

Using Rank Number in CKF for rows and columns in Bex

30 Views

Hi All,

I have one issue while using "Rank Number" in CFK.

I have used the feature of "Calculate Single values as" = Rank Number in the CKF.

And got the below result which is good till now. ( Here the Month is in rows )

PortFrom PortTo Month Qty Rank

ABC XYZ 05.2013 10 3

ABC XYZ 05.2013 5 1

ABC XYZ 05.2013 8 2

Now , when i shif the Month into Columns above the KF , the Rank Figures changes to X

Month 05.2013

PortFrom PortTo Qty Rank

ABC XYZ 10 X

ABC XYZ 5 X

ABC XYZ 8 X

Here as per the Rank Number defination it will calculate in only 1 direction either in rows and columns.

Please let me know hoe do i figure out this problem.

Thanks in advance.

Sagar