To count purchases not tied to any campaign in a pivot table, you should:

• A. Use a filter to show only non-campaign rows.
• B. Insert None as the campaign code for non-campaign purchases.
• C. Exclude all non-campaign purchases from the data set.
• D. Assign each non-campaign purchase a unique campaign code.

Answer: (B)

The key idea is to treat every purchase as belonging to a campaign category, even when there isn’t one. By placing None as the campaign code for purchases that aren’t tied to any campaign, you create a distinct category in the pivot table (a clear “no campaign” bucket). This lets the pivot count how many purchases fall into each campaign, including those without a campaign, without discarding them from the data.

Using a filter to show only non-campaign rows would restrict the view to just those purchases and won’t give you the overall counts by campaign. Excluding non-campaign purchases from the data set would remove them entirely from totals, so you’d lose that information. Assigning each non-campaign purchase its own unique campaign code would inflate the data with many separate codes and misrepresent the idea of a single “no campaign” category.