If you want to compare purchases by state in a pivot table, which area should you place the State field in?

• A. Columns
• B. Rows
• C. Values
• D. Filters

Answer: (B)

Placing the State field in the Rows area creates a separate row for each state, which is exactly how you want to compare purchases across states. This arrangement lists states vertically, and the numeric measure (like total purchases) sits in Values so you can see each state's total side by side in one table.

If you put the state in Columns, you’d have each state as a column header, which can be harder to read when there are many states. In Filters, you could restrict which states appear, but you wouldn’t get a full side-by-side comparison. So using Rows gives a clear, readable vertical comparison of purchase totals by state.