OK. I realize it will mean some work, but I agree with your boss, it is the 'correct' thing to do.
And someone else just made another post and raised a good point...I had only mentioned SUM()...there are other functions (COUNT, MAX(), etc...). Basically, functions that are doing some form of aggregation/analysis on multiple rows and returning one value.
Kevin