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.
I need to know if there is a way to add up the comp fields to get the sum as a vend rebate field. I used cube and rollup withou success. Any help would be appreciated. ![alt text] :