Forum Discussion
Sales Analysis
I have two tables
- What are the key performance trends YoY in the period?
- Are any of the customers dropping in performance for their respective contracts?
- Are the Sales in EA (individual units) mirroring the Gross/Net sales performance?
- Any other trend you are noticing?
- What recommendations do you have for extra analysis that could be performed and what
extra data sets would you need to do this?
My Tasks Can Anybody Please help me out how can i do those thanks a ton
Item Info
| Item | Agreement Number | Agreement Detail | Pricing UOM | Conv Factor | Item Description-Cleaned |
Customer Info
| Date | Agreement Code | EFF Date | EXP. Date | Gross Sales | Net Sales | Lost Cause | Lost Cause Value | Qty UOM | Pricing UOM | SOLD_TO_CUST_ID | HM_CUST_ID | HM_CITY_NM | HM_ST_CD | Agreement Type | INT_PRICE_CNTRCT_NUM | CONTRACT NAME W/O T/L | Material Id | Material Heirarchy Lvl1 | Material Heirarchy Lvl2 | Material Heirarchy Lvl3 | Material Name | OXIMETRY/CAPNOGRAPHY | ALLIED_CD | ALLIED_GRP_NM.1 | ALLIED_GRP_NM. |