Elsie created a pivot table from 5,000 records of source data that groups employees by the following departments: Engineering, Fulfillment, Support, Sales, and Marketing. For budgeting purposes, she wants to group these five departments into two groups – Group 1 (which includes Engineering and Support) and Group 2 (which includes Fulfillment, Sales, and Marketing); however, these groups do not appear in the source data. What can she do? a. Create the Group 1 and Group 2 groups manually.
b. Add a calculated item to each group, and then group by the item.
c. Recreate the source data range, and arrange the data into the desired Group 1 and Group 2 groups.
d. Add a calculated field to the pivot table for grouping purposes.