I have two cross tab queries which I am trying to combine into a logical format.
In the first, I have two row headings - employees & type of hours (billable/non-billable). My column headings are the months. The results are the sum of each hour type for the employees.
In the second, I have one row heading, employees. My column heading are the months. The results are the sum of the available employee hours.
I'd ideally like to have the second crosstab query results, end up as another row heading in crosstab 1 - i.e. employees & type of hours (billable/non-billable/available).
Any idea how I can accomplish this? I've tried a couple of different approaches without any luck.
Thanks in advance!