I have a cross tab query that returns me sales peoples sales on YTD basis.
So i have sales x, sales April, Sales May
Unfortunately as the data is YTD, the only way we can view month by month basis is to subtract May from April, and the uplift in sales is Mays figures
So can i create a query that looks at columns May and April and returns all sales people with the uplift data i.e May minus April
In the attached spreadsheet i added a column to show the expected result