Welcome to Excel Workout #10!
This week’s challenge is designed to test your knowledge on Pivot Tables.
Pivot tables in Excel are powerful tools for data analysis that allow you to summarize and analyze large amounts of data quickly and easily. Pivot tables allow you to create summary reports from large data sets by grouping, filtering, and sorting data based on different criteria.
Please follow the directions given below, which include downloading the Excel worksheet required to perform the challenge tasks. Once you have completed the download, proceed to take the challenge and test your skills.
Calculate Sales in Euro for each Store
Examine the sales figures for each store in the
coming year, comparing them to the previous year’s
figures using both absolute differences and
Compute the cumulative totals for each store on
an annual basis, expressed in Euros and as a
Reply to this post with your formula code and solution file. Please be sure to blur or hide your formula code.
This workout will be released on Thursday April 27, 2023 , and the author’s solution will be posted on Wednesday May 3, 2023 .
Challenge #10.xlsx (8.4 MB)
For Difference with preveious years Steps
All values are sales figure in Value field list what makes it different is the Show value As.
For the other part, I will be showing the Step 2 and 3 only.
Sales % Difference
Cumulative Sales %
Quadri Solution to Challenge #10.xlsx (8.5 MB)
Quadri Atharu | LinkedIn
Here is my file.
Challenge #10.xlsx (1.8 MB)
@IlgarZarbaliyev, Thank you for considering the suggestion and adding the report. It helps us and we can solve the task without confusion.
I have followed the same steps as excellently demonstrated by @QuadriAtharuOlayinka. I don’t want to clutter here.
Challenge #10.xlsx (8.5 MB)
Seeing the sample made it easier for me to comprehend it as well.
Thank you for your active participation, @QuadriAtharuOlayinka . You are doing great! Congrats!
Thank you for the Workout on pivot Tables. Its a good review for me.
Please see attached file
Excel Workout Challenge #10 Keith Smith.xlsx (8.5 MB)
Pivot table Headings for Difference, Difference % , Cumulative Sales, and Cumulative %
is on sheet1 within the file.
Thank you for participating in the Excel Challenge related to Pivot Tables! I hope you found this challenge to be a fun and engaging way to improve your Excel skills and learn more about how to work with Pivot Table in Excel.
Here is my solution to Workout #10:
Challenge #10 with Solution.xlsx (8.5 MB)
Once again, thank you for participating in this Excel Challenge, and I look forward to seeing you in future challenges and learning opportunities!
Just loved this workout! Never realized how powerful Pivot Tables are in summarizing and analyzing data.
Additionally, I’ve visualized Sales and Cumulative % Sales graphically, along with a Slicer to gain quick insights.
Find the report here:
C10_Pivots2_Homesh.xlsx (186.2 KB)
@IlgarZarbaliyev - Another interesting way into Pivot Table. Thank you for this workout
Snapshot of PivotTable:
Here’s my workout file: Challenge #10.xlsx (8.5 MB)