Which method can be used to determine the number and percentage of purchases from each campaign?

• A. Filter for each campaign code first, then sort by discount code.
• B. Sort data by the discount code in Column F in descending order, then filter for each campaign code to count instances.
• C. Use a PivotTable with region.
• D. Apply a formula to sum all campaign codes.

Answer: (B)

Determining how many purchases came from each campaign and what percentage that represents requires grouping by campaign and counting, then calculating each group’s share of the total.

Sorting the data by the discount code in that column groups all rows with the same campaign code together. After that, filtering for a specific campaign code narrows the view to just that campaign, making it easy to count how many purchases belong to it. Repeating this for every campaign code gives you the exact purchase counts per campaign, and dividing each count by the total number of purchases (then multiplying by 100) yields the percentage for each campaign. This approach uses straightforward spreadsheet tools to produce both the counts and the percentages without needing additional features.

Other options aren’t as direct: filtering for each campaign code and then sorting is more repetitive and error-prone; a PivotTable could work, but the given choice focuses on a simple, step-by-step method with basic features; summing a campaign code wouldn’t provide counts or percentages of purchases per campaign.