I am trying to make a report for out salesman on a per month basis. The problem I am currently at is I have a query made to filter down to the specific salesman then each of their customers to a per month amount. I can't figure out what my next step is in the query to get it more presentable. I feel like a crosstab is what I need, but am unsure.
It almost feels like I need multiple crosstab's to achieve what I am after. I need to consolidate the query to per salesman, then to per contractor, then to per month. Then each month needs to show sale, cost, profit and profit %. Would anyone happen to have an example of what I am trying to make?
It almost feels like I need multiple crosstab's to achieve what I am after. I need to consolidate the query to per salesman, then to per contractor, then to per month. Then each month needs to show sale, cost, profit and profit %. Would anyone happen to have an example of what I am trying to make?