I'm creating another report and have run into the following issue: Two of the fields I'm using are INV TOTAL - YTD and TOTAL DOLLAR VALUE (of the last invoice). Let's say, I have a customer called WINNER. In this report, I have 10 lines for this customer that all show $11,760 in the INV TOTAL -YTD column. If I select the INV TOTAL - YTD field using the SET SORT ORDER and then click on the SUMMARIZE button, GridView properly summarizes it by displaying $11,760 as the total sum.
However, if I set the search order any other column (e.g. the TOTAL ORDER VALUE column) and click on the SUMMARIZE button, the INV TOTAL - YTD column suddenly adds up those $11,760 however many times it appears in the list in this case 10 times) and I end up with a sum of $117,600 - which is obviously wrong.
How do I get around or fix this? In my opinion, GridView should 'know' that any YTD, LY, PTD like column should only count once.

Another question along those same lines is this: Is there a way to say I want to get (sub)totals for certain columns and not for others? Would I have to use Crystal reports for something like that?

Thanks much!

Andre