year. She decides to create a PivotTable to better manipulate and filter the student group data.

Switch to the Academic PivotTable worksheet, then create a PivotTable in cell A$1$ based on the AcademicGroups table. Update the PivotTable as follows so that it matches Final Figure $2$:

a$.$ Change the PivotTable name to: AcademicPivotTable

b$.$ Add the Activities field and the Group Name field $($in that order$)$ to the Rows area.

c$.$ Add the $2024,2025,$ and $2026$ fields $($in that order$)$ to the Values area.

d$.$ Change the display of subtotals to Show all Subtotals at Top of Group.

e$.$ Change the report layout to Show in Outline Form.

f$.$ Update the Sum of $2024$ field in the Values area to display the name $2024$ Membership with the Number number format with $0$ decimal places.

g$.$ Update the Sum of $2025$ field in the Values area to display the name $2025$ Membership with the Number number format with $0$ decimal places.

h$.$ Update the Sum of $2026$ field in the Values area to display the name $2026$ Membership with the Number number format with $0$ decimal places.