Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Problem with porcentual function in hierarchy

Hi friends;

I have a issue in bex query designer with a porcentual function. I attached an example of what I need, what I need is a percentage based on the total of each group of the hierarchy (0MATERIAL) and not on the overall total:

I test with %CT and %GT functions, but booth works with the total general, and not with total group...

Y need the values of the column "MIX (value OK group material" and not the values of the column "MIX (error)".

Hierarchy

Quantity

MIX (error)

MIX (value OK, group material)

Materials (general)

45

100

100

Group Materials "X"

30

66,67

100

Material X1

20

44,44

66,67

Material X2

10

22,22

33,33

Group Materials "Y"

15

33,33

100

Material Y1

5

11,11

33,33

Material Y2

10

22,22

66,67

Any idea to solve this?

Best regards!

C├ęsar.

Former Member
Not what you were looking for? View more on this topic or Ask a question