Incorrect Query Result(Urgent) BW 3.5

Dear All,

I am using BW 3.5 here.

I have made a query to show the following figures:

(A) (B) (C) (D) (D/C) (E) (D/C*E)

Plant Material Mat. Qty Mat. Amt Unit Price In Qty In Amt

-

---

-

---

-

---

-

---

-

---

-

---

-

---

P1 M1 10 30 3 6 18

P1 M2 20 40 2 8 16

-

---

-

---

-

---

-

---

-

---

Result 30 70 5 14 34

It looks fine in this way, but when I remove the Material(B) from drill-down the result become meaningless:

(A) (C) (D) (D/C) (E) (D/C*E)

Plant Mat. Qty Mat. Amt Unit Price In Qty In Amt

-

---

-

---

-

---

-

---

-

---

-

---

P1 30 70 5 14 70 <--- Wrong

Can anyony sugguest a way to keep the same result before removing the Material from report(In Amt should still be 34) ??

Thanks a lot~~~

B.R

Charlie Lin