The picture below shows categories (comp upg, comp ftr, etc.) and a sum total (Vend_Rebate). The process below was created using FileMaker Pro 11. My company is getting away from FileMaker, and I will now have to do this process using SQL Server 2008 R2.
![alt text]: http://ask.sqlservercentral.com/storage/temp/172-subtotal.jpg
asked Apr 17 '12 at 02:54 PM in Default
Not sure of your underlying data, but here's a mockup that shows how you could use ROLLUP
order by col3, col2
answered Apr 17 '12 at 03:13 PM
Kev Riley ♦♦