Need help to make Awesome Report

[aparvez007]

Hi Ninjas & All,


please share me report, Format & idea on below topic.


1. Weekly salesman performance against target

2. Area performance against budget-Dashboard

3. Customer Performance Tracking


https://www.dropbox.com/s/8jvq917i6rnqsuh/Book1.xlsx


Thanks

Pavi

 

[aparvez007]

Hi All,


Please suggest me any format for my report.


Regards,

Pavi

 

[Raja Kamarthi]

@parvez:


Can you please clarify the below:


Column K has Amount and Column L has Cost, now what does this "COST" refer it.


-->Is it the actual cost to the company?

-->Does (Amount - Cost) give the "Profit/Income" value?


Raja

 

[Hui]

@Raja


You have posted in the wrong post?

 

[Raja Kamarthi]

My apologies for the wrong post


@Hui,


Thanks for this correction


Raja

 

[kaushik03]

Hello Pavi,


Can you plz answer my below questions?


1)For salesmen, what is the performance parameter(col heading) and what is the target?


2) For customer, which Cols should I consider for performance and budget?


Kaushik

 

[aparvez007]

Thanks kaushik for your reply...


Actually I not yet received the Salesmen Target from respective country or area.

I just want your suggestion on dummy data.


For salesmen & Customer parameter is Amount.


@Hui Sir,


Raja's question is related to my post only.


Raja Cost column refering cost for particular product & Brand.


Thanks

Pavi