SUMCT Result Problems

[Former Member]

Hi,

I am trying to get the total number of lines for the result to appear on each line of the report based on the drill level. I created formula1 that uses a keyfig. In formula1 I use SUMCT with keyfig and it has no effect on each individual line and it gives me the Overall Result instead of Result. I am wanting 5 to appear in each line below but the individual lines come out the same as the original keyfig and the Result line shows as the Overall Result in this case 10.

In formula2 I use the SUMGT with keyfig and it gives me 10 for every line and not 5.

How can I get the 5 to appear?

Material Customer keyfig formula1 formula2

-

---

-

---

-

---

-

---

-

---

A A 3 3 10

B 2 2 10

C 2 2 10

D 2 2 10

E 1 1 10

Result 5 10 10

B A 3 3 10

B 2 2 10

C 2 2 10

D 2 2 10

E 1 1 10

Result 5 10 10

Overall Result 10 10 10

Thanks

Eric

[Former Member]

Hi eric,

I'm not sure if I understood your requirements properly.

Looks like you may to implement scenario in the

"How to … Count the occurrences of a characteristic":

http://service.sap.com/bi

Media Library -> HOW TO... Guides -> Guide List SAP BW 2.x

Best regards,

Eugene