What is the best way to do this?
I have a query which groups and counts data. I also need to 'filter' that same data so I can get a percentage between the two.
For instance, query1 would return the total:
I then need query1 to be the filtered data:
So the final results would something like