Grasshopper you're concept worked beautifully! I can't believe I didn't think of that sooner - so simple!

Here's what I did to accomplish my...

Thanks for all of the input!

The WITH ROLLUP worked perfectly for totaling the columns. Now I need to total the rows. When I use a count(*) it counts all machines...