Exercise Info

• Application (Classic vs Data Prep Studio): Classic
• Level of Difficulty (Beginner, Intermediate, Advanced): Beginner
• Skills/Features Tested: Report Trapping, Calculated Fields, Filters, Summary
  
• Systems of Record: Not Applicable
• Estimated Time to Solve: 10 mins
• Exercise files required are attached
  • Grocery.txt

Exercise Overview

You are a Sales Operations Analyst working at a Grocery chain and your manager has asked you to answer the following questions using Altair Monarch Classic by analyzing the Grocery.txt file:

1. What is the Total Sale for the day?
2. Which Department (Produce, Bakery, Dairy) generated the most sales?
3. Which Product in Bakery generated the most sales?

Answer

• Please upload your answers below in the comment section for the exercise
• A Video Answer to the question will be published within 7-10 days on the Monarch Succcess Plan page in the 'Monarch Learning Series Solution' section.