Question 5
Which of the following is typically NOT performed when using a pivot table in data analysis ?
Filtering data to display only specific records.
Creating new records in the original dataset.
Grouping data by categories or fields to analyze trends and patterns.
Summarizing data by aggregating values, such as sum, count, or average.