Answered step by step
Verified Expert Solution
Question
1 Approved Answer
In the green cells calculate total Gross Profit (i.e., Sales - COGS) using the condition(s) as specified and without creating a helper column, using Filters,
In the green cells calculate total Gross Profit (i.e., Sales - COGS) using the condition(s) as specified and without creating a helper column, using Filters, or Pivot Tables.
| Date | Product | Region | SalesRep | Customer | Sales | COGS | Gross Profit | ||
| 4/19/2020 | Product3 | Region3 | SalesRep2 | Customer16 | $ 14,046 | $ 5,337 | All products: | ||
| 4/19/2020 | Product7 | Region4 | SalesRep15 | Customer72 | $ 2,504 | $ 1,703 | Product9 only: | ||
| 4/19/2020 | Product2 | Region4 | SalesRep18 | Customer71 | $ 1,505 | $ 843 | Product3 and SalesRep16 only: | ||
| 4/19/2020 | Product6 | Region4 | SalesRep14 | Customer88 | $ 4,232 | $ 2,793 | |||
| 4/19/2020 | Product3 | Region4 | SalesRep3 | Customer65 | $ 5,947 | $ 3,390 | |||
| 4/19/2020 | Product1 | Region8 | SalesRep6 | Customer100 | $ 5,721 | $ 3,204 | |||
| 4/19/2020 | Product10 | Region8 | SalesRep16 | Customer68 | $ 14,744 | $ 5,308 | |||
| 4/19/2020 | Product7 | Region2 | SalesRep1 | Customer85 | $ 4,018 | $ 2,371 | |||
| 4/19/2020 | Product10 | Region5 | SalesRep6 | Customer6 | $ 6,442 | $ 4,445 | |||
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Financial Accounting Longman Modular Texts In Business And Economics
Authors: Christopher Waterston, Anne Britton
2nd Edition
058238169X, 978-0582381698
