Which statement best describes the percentage of total purchases in a pivot table?

• A. It is computed by dividing the overall total by each campaign's count
• B. It is computed by multiplying each campaign's count by 100
• C. It is computed by dividing the count for each campaign by the overall total and formatting as percent
• D. It is the sum of all campaign counts divided by the number of campaigns

Answer: (C)

Percentage of total shows each category’s share of the whole. In a pivot table, you take the count (or sum) for each campaign and divide it by the grand total across all campaigns, then format that result as a percent. For example, if the grand total purchases is 1,000 and a campaign has 250 purchases, its percentage of total is 250/1000 = 25%. This is exactly what the statement describes: dividing the category’s count by the overall total and formatting as percent. The other choices don’t express a share of the grand total: reversing the ratio, multiplying counts by 100, or averaging counts would not show each category’s proportion of the total.