Sales Analysis

[SumitDubey]

I have two tables

1. What are the key performance trends YoY in the period? 
2. Are any of the customers dropping in performance for their respective contracts? 
3. Are the Sales in EA (individual units) mirroring the Gross/Net sales performance?  
4. Any other trend you are noticing? 
5. 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.

[Anonymous]

Hi @SumitDubey ,

Can you provide us with your data source file? The two tables about performance trends YoY?

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.