You defined a condition in a query for the top 10 customers based on sales revenue (key figure of type Sum). If you keep the default settings of the query, what is the total of the sales revenue on…

Question

Options

• ASales revenue total of all customers
• BSales revenue total of the 10 customers
• CSales revenue value of the 1st customer
• DSales revenue value of the 10th customer

• A
  3% (1)
• B
  94% (29)
• C
  3% (1)

Explanation

When a condition (Top 10 by sales revenue) is applied in an SAP BEx query, the result line aggregates only the rows that are actually displayed - the 10 customers returned by the condition - so the total reflects their combined revenue, not the full dataset. Option A is wrong because the condition filters out all other customers; the result line does not "look through" the filter to sum the entire customer base. Options C and D are wrong because the result line is an aggregated total (Sum key figure), not a single customer's individual value. A useful memory tip: the result line respects the condition - think of it as "what you see is what gets summed," so the displayed rows drive the total.

No community discussion yet for this question.