Toggle navigation
GoSkills
Courses
Courses
Train your organization
Supercharge your organization with expert-led business and productivity courses.
Learn more
Learn on your own
Earn certifications for the most in-demand skills with unlimited access to all GoSkills courses.
Learn more
Explore our courses
Browse our award-winning library of 110+ business and productivity courses delivered in bite-sized lessons.
Explore courses
LMS
Course builder
Resources
Pricing
Organization pricing
Individual pricing
Pricing
Search
Sign up
Log in
Log in
Signup
Quiz
1
Advanced
You have the PivotTable shown below and want to display the percentage of the category compared to the grand total for each row of the table. How would you do it?
Drag Amount on to the Pivot again > right-click the new column > Show Values As > % of Row Total
Drag Amount on to the Pivot again > right-click the new column > Show Values As > % of Column Total
Create a formula in C2 that reads “=B2/B$11”, then copy it down the table.
Don’t know
2
Advanced
You’ve got a PivotTable set up with Years on rows, Class on columns, and Sales $ on values (twice). Both Sales $ columns are currently set to aggregate as a Sum, but you’d like to display the second column as a % of the previous year, as shown below. What do you need to do?
Right-click the Time Period column > Show Values As > % of… and set the Base Field to Years, and the Base Item to (previous)
Right-click in the column > Value Field Settings > Show Values As > % of… and set the Base Field to Class, and the Base Item to (previous)
Right-click in the column > Show Values As > % of… and set the Base Field to Years, and the Base Item to (previous)
Don’t know
3
Advanced
While we often display a basic aggregation with our “% of” measures, it’s not entirely necessary. Assuming you have the following PivotTable with Categories on rows, Class on columns and the default Sum of Amount on values, how would you convert it to show as follows?
Right-click in the values area of the PivotTable > Show Values As > % of Grand Total
Right-click in the values area of the PivotTable > Show Values As > % of Column Total
Right-click in the values area of the PivotTable > Show Values As > % of Parent Total
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement