Answered step by step
Verified Expert Solution
Question
1 Approved Answer
table [ [ Measure name,Formula ] , [ TotalSales , TotalSales Regular _ Sales _ Dollars Measure name TotalSales Total Units This Year Regular
tableMeasure name,FormulaTotalSalesTotalSales RegularSalesDollars
Measure name TotalSales Total Units This Year Regular Sales Dollars Markdown Sales Dollars Avg S/Unit TY TotalSalesTY TotalUnits Regular Sales Units Markdown Sales Units Total Sales Variance Total Sales Var TotalSalesTY TotalSa1esLY This Year Sales TotalSa1esTY Formula TotalSa1es Total Units This Year Regular_Sa1es_D011ars Markdown Sales Dollars SLIM( ] ) SLIM( Dollars]) Avg $/lJnit TY = Units This Year [TotalSa1esTY]/CTota1 Units This Year], TotalSa1esTY = Sales BLANK()) TotalUnits Markdown Sales Units Total Sales Variance Units] SUM( ) SUM( [ ] ) [Total Sales Var] Total Sales Var [TotalSa1esTY] - [TotalSa1esLY] TotalSa1esTY = TotalSa1esLY = This Year Sales TotalSa1esTY = [TotalSa1esTY] Sales C Sales C Sales C
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