In a pivot table, what do the Rows represent?

• A. They display selected values from the data, categorized horizontally (e.g., by state)
• B. They display the data values aggregated by column totals
• C. They show the page-level filters applied
• D. They summarize data by calculating averages

Answer: (A)

Rows in a pivot table define how the data is grouped and displayed. They show the distinct values of the field you place there, so you end up with a separate row for each category (for example, one row per state) and the measures in the Values area are calculated for each of these rows. This is why rows represent the selected values from the data used to categorize the data, such as states. The other areas handle other functions: column totals come from the Columns setup, filters control which data is included, and averages or other aggregations come from the calculations in the Values area.