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.
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
answered Apr 17 '12 at 03:13 PM
Kev Riley ♦♦