Hi Guys,
I need to create a Funnel Plot to show performance in Crystal 2008.
Can anybody help me with that please?
Scenario:
There are Six members in the sales team and i want to evaluate their performance depending upon the profit on their sales.
e.g for the month of Dec 2010
Mike's sales = 5000 and profit = 50
Kevin's sales = 10,000 and profit = 200
Katie's sales = 7500 and profit = 100
Paul's sales =15000 and profit = 500
Nick's sales = 8000 and profit = 250
Simon's sales = 3500 and profit = 100
There are three factors 1-total sales, 2-total profit and 3-goods type. Some of the items are difficult to sell and for that we have a formula to calculate the level of difficulty in selling.
Please help!