Question: Tables Abc Manager Firstname Abc Manager ID Abc Manager Lastname Abc Manager Level Manager Since Abc Manufacturer Order Date Abc Product Code # Product ID
Tables
Abc Manager Firstname
Abc Manager ID
Abc Manager Lastname
Abc Manager Level
Manager Since
Abc Manufacturer
Order Date
Abc Product Code
# Product ID
Abc Product Name
Abc Region ID
Abc Region Name
# Store ID
Abc Store Name
Abc Store Type
Abc Measure Names
# Commission
# Gross Sale
# Margin
# Net Sale
# Order
# Store Customers
# Total Commission
# Total Cost
# Trans. Discount
# Transaction
# Unit Cost
# Unit Margin
# Unit Price
# Units Sold
# SheetCount
# Measure Values I just need advice on what goes on the rows and what goes on column. We are concerned about our discount policies and the performance of our products and stores. In order to have a better perspective on these issues, you should create the following charts:
A Dual Axis line chart where we can see month by month the trend of the transactions' Average Discount and the trend of the transactions' Total Margin. Do not synchronize the axes, so we can compare whether the two trends have moved together chronologically, but make sure we can identify what axis corresponds to each line.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
