Skip to Content

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

Restricted key figure advice please...

greetings sdn. i need your advise on how to go about this type of report layout.

i have 2 main columns, customer type and customer type b. and then 3 sub columns; consumption ranges and total.

each customer should only fall in one category, either type a or type b.

type a type b

(1-10) (11-20) tot (1-10) (11-20) tot

cust x 1 1

cust y 1 1

i made 2 restricted key figures; the 1st is volume restricted by the customer type a and the 2nd is also volume restricted by customer type b.

when running the report, the customer volumes fall in the right columns. however, each customer is counted in both sub column totals.

type a type b

(1-10) (11-20) tot (1-10) (11-20) tot

cust x 1 1 1

cust y 1 1 1

your advise will be most appreciated.


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