Your company has 100 product subcategories and more than 10,000 products.
You have a PivotChart that uses Manufacturer as the axis and the sum of SalesAmount as the values.
You need to ensure that only the top 10 manufacturers appear in the chart.
What should you do?
A. Configure the Value Filters
B. Summarize the SaleAmount field by Max
C. Change the format of the SalesAmount field
D. Create a calculated column