Filtering Calculation

[joshw]

I have a sales report I created, and we have two summary fields that counts how many sales and adds the dollar amounts of each sale. I need to be able to create two separate versions of these summary fields, filtered by customer type (new and remodel). 

 

I thought about using a portal filter, but I can filter the same table that layout is associated with. 

 

Instead of leaving these as Summary fields, I thought that I could create them as calculation fields. But I don't know what calculation I could use, and where I should start.

 

Any thoughts?

[LaRetta]

If you add a leading part based upon Customer Type, and also SORT by this Type field, then the same summary fields can be copied and placed in the leading part. You could delete the entire body if you only want the totals of each.