Using select and crosstab queries on one report

[derfel]

I created a report based on a crosstab query which shows a count of items by
therapeutic category (row field) and month (column field). So far so good.
Now I want to add in a column on my report which uses a select query to count
"unreviewed" items in each therapeutic category (ignoring month). So far I
have been unable to figure out how to get this total to show in my report. Is
it possible to use both queries on the same report? Or do I need to rethink
my crosstab query?

 

[KARL DEWEY]

Post the SQL of both queries and what signifies that item is "unreviewed".