Display the Max of Line Items

Dear All,

I am new to BW. Please help me resolve the following issue.

To display only the maximum amount in the line item of a PO.

I created a new formula KF with the PO amount and then changed the property to "calculate result as" - "maximum".

When I run this query along with the line no. I can see in the result the maximum of all the line item as below:

Doc# -

Line#-- Amount --Max

001---- -1

29.87

001---- -2

12.36

-

RESULT--

29.87

But, if I select the line no as free char. My output is:

Doc# -

Amount----Max

001--

I need the output as :

Doc# -

Amount----Max

001--

29.87

When I checked the prev posts I came across a solution to create Calc Key figure. But, I am not authorized to create any CKF.

I will thank any answers with points.

Thanks in advace.

Rad