Pivot tables can share insights with stakeholders by showing which of the following measures?

• A. The percentage of purchases from each campaign.
• B. The exact sum of all monthly expenses.
• C. The average invoice value per customer.
• D. The list of all individual customer names.

Answer: (A)

Pivot tables are powerful for turning large data into clear, comparable views by aggregating values across categories. They let you quickly calculate how much each category contributes to the whole, which is especially helpful for stakeholders who need to see relative performance at a glance. Showing the percentage of purchases from each campaign provides a concise, comparative view of how effective each campaign is in driving sales, making it easy to identify which campaigns are leading the way and where to focus resources. While a total monthly expense sum, an average invoice value per customer, or a list of individual customer names can be useful in other contexts, they don’t offer the same quick, cross-category insight that a percentage of total purchases by campaign does.