Hi Guys,

I'm hoping someone can help me with a report I'm trying to build.

We have a sales journey for our salespeople in this order:

What I need to do is create the current month's KPI based on the previous month's performance.

1. Apps passed are static and set to 15 for each salesperson

2. Packaged is the total of Apps passed the previous month * 32%

3. Offered is the total of Packaged cases from the previous month * 53%

How do I write a query that provides me with this data?

Any help would be greatly appreciated.

Thanks