Using Rank Number in CKF for rows and columns in Bex

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