Display the Max of Line Items

[Former Member]

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--

---

29.87

001-----2

---

12.36--

---

12.36

-

---

RESULT--

---

42.23--

---

29.87

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

Doc# -

---

Amount----Max

001--

---

42.23----42.23

I need the output as :

Doc# -

---

Amount----Max

001--

---

42.23--

---

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

[Former Member]

You will need to use CKF for this.