To display campaign codes across the top of the pivot table, which area should hold the Campaign Code field?

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

Answer: (B)

Placing the Campaign Code field in the Columns area determines how the pivot table lays out the codes: each code becomes a separate column header across the top. In a pivot table, Columns create the horizontal axis of labels, while Rows create the vertical axis on the left, Values show the aggregated measures inside the grid, and Filters provide a way to restrict what’s shown. By putting Campaign Code in Columns, you can compare key metrics side by side for each campaign code, which is exactly how you’d want to visualize cross-code performance. If it were in Rows, the codes would appear down the left side; in Values, you’d be aggregating the codes themselves (not meaningful); and in Filters, you’d only filter the entire table by codes rather than display them across the top.