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
Assuming you were given the following PivotTable, but it was missing the last column. What would you need to do in order to add a column to show the % difference of each year related to 2009 as shown below?
Add the Sales $ column to the PivotTable again, change it to Show Values As > % Difference From > configure the Base Field to Time Period and Base Item to (previous)
Add the Sales $ column to the PivotTable again, change it to Show Values As > % Difference From > configure the Base Field to Sales $ and Base Item to 2009
Add the Sales $ column to the PivotTable again, change it to Show Values As > % Difference From > configure the Base Field to Time Period and Base Item to 2009
Don’t know
2
Advanced
Assuming you were given the following PivotTable, but it was missing the last column. What would you need to do in order to add a column to show the % difference of each year related to the prior year as shown below?
Add the Sales $ column to the PivotTable again, change it to Show Values As > % Difference From > configure the Base Field to Time Period and Base Item to (previous)
Add the Sales $ column to the PivotTable again, change it to Show Values As > % Difference From > configure the Base Field to Time Period and Base Item to 2009
Add the Sales $ column to the PivotTable again, change it to Show Values As > % Difference From > configure the Base Field to Sales $ and Base Item to (previous)
Don’t know
3
Advanced
How did the author configure the % Diff vs 2013 columns for this PivotTable?
They went to Show Values As > % Difference From > set the Base Field to Years and the Base Item to 2013
They went to Show Values As > % Difference From > set the Base Field to Category and the Base Item to (previous)
They went to Show Values As > % Difference From > set the Base Field to Category and the Base Item to 2013
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement