When totaling data on a report, how many aggregations can you select per row?

• A. One
• B. Four
• C. Two
• D. Three

Answer: (A)

When totaling data on a report, you apply exactly one aggregation function to the value in each row. This keeps the summary for that row clear and unambiguous because a row contains a single numeric value, and selecting one way to summarize it (for example, sum, average, count, minimum, or maximum) defines how it contributes to the overall totals. If you tried to apply more than one aggregation to the same row, the results would conflict and become unclear. If you need multiple kinds of totals, you would create additional fields or separate rows/columns with their own aggregations, rather than stacking multiple aggregations on the same row.