In a pivot table, what do the Columns represent?

• A. They display selected values from the data, categorized vertically (e.g., by campaign code)
• B. They display row labels
• C. They show the grand totals
• D. They hold page filters

Answer: (A)

Columns in a pivot table are the category axis that partitions data horizontally by the field you place in the Columns area. Each distinct value of that field becomes a separate column header, and the corresponding cells show the aggregated measure for that category. If you stack multiple fields in columns, you get a nested set of column headers representing combinations of those values. This setup lets you compare the same metric across different categories side by side. For example, placing Campaign in the Columns area creates a column for each campaign, so you can see how the metric (like sales or clicks) differs by campaign while other dimensions (like product or month) form the row labels.