An analyst is working on a pivot table and needs to figure out how many new products in each year earned less than $3 million. What does the analyst do to view these new products?

While adding a formula can perform calculations on data, it does not directly filter the existing data in a pivot table. Formulas are typically used to create new calculated fields or to manipulate data outside of the pivot table structure, which does not address the requirement to filter products based on revenue directly.

A calculated field is used to create new data within the pivot table based on existing data. However, it does not provide a mechanism to filter the data based on specific criteria like revenue thresholds. Instead, it computes values that may not assist in isolating products that earned less than $3 million.

The fill handle is a feature used to extend or copy data and formulas in Excel, but it does not apply to filtering data in a pivot table. Its function is unrelated to the task of identifying specific products based on their earnings, as it simply facilitates data entry or duplication.