Learn

Platform

For Business

Pricing

Resources

/

#3

Rolling Up, Looking Back

Rolling Up, Looking Back

Your Objective

Your Objective

You’ve been given a table with raw data for individual coffee shop transactions. Your task is to aggregate the total sales by month and store, then calculate the month-over-month change in sales for each store (in dollars).

Example input and output:

Submit your solution

What was the difference in sales from April to May for the Astoria location? (digits only, rounded to the nearest dollar)

Watch the solution video & tutorial

FOR INDIVIDUALS

Master modern data skills

Start learning for Free. No credit card required. Master skills in AI, Excel, Power BI, SQL, Python and more.

FOR COMPANIES & TEAMS

Train your team in data

Create your team account today, request a demo, or start with a team assessment today.

FOR INDIVIDUALS

Master modern data skills

Start learning for Free. No credit card required. Master skills in AI, Excel, Power BI, SQL, Python and more.

FOR COMPANIES & TEAMS

Train your team in data

Create your team account today, request a demo, or start with a team assessment today.

FOR INDIVIDUALS

Master modern data skills

Start learning for Free. No credit card required. Master skills in AI, Excel, Power BI, SQL, Python and more.

FOR COMPANIES & TEAMS

Train your team in data

Create your team account today, request a demo, or start with a team assessment today.