Hi,

I am working with a client that wants to produce a quote that lists all OpportunityLineItems sub-divded by Product family. I have controller that display Opportunitylineitems on VF page as below...

Basic                 1.0  1    03/08/2012  12  USD 149.0  USD 1788.0
                            1.0  12  25/07/2012  10  USD 300.0  USD 3000.0
                            1.0  12  16/08/2012  11   USD 273.0 USD 3003.0

                                                                                              subtotal????

Custom              1.0   03/08/2012   USD 1800.0
Single                 1.0    03/08/2012  USD 5500.0
                                                             subtotal????

How can i do the subtotal of each product family? Here is the controller that works fine without subtotal.

class:

public class OppsControllerExtension {

    private final Opportunity opps;
    
   public OppsControllerExtension(ApexPages.StandardController stdController) {
        this.opps = (Opportunity)stdController.getRecord();

}

List<OpportunityLineItem> OppsLicence = [SELECT id, ServiceDate, Opportunity.name FROM OpportunityLineItem 
                                         WHERE License_service__c = 1 AND Opportunity.id = 
            :System.currentPageReference().getParameters().get('id')];
   
        public integer getLicenceRowNumber() {
            if (OppsLicence.size() >= 1)
            return OppsLicence.size() - 1;       
           
        else
            return 0;
        }
        public list <OpportunityLineItem> getLicenceServicelist () {
        return [SELECT id, ServiceDate, License_service__c, PricebookEntry.Product2.Quote_service_group__c, PricebookEntry.Product2.Quote_service_schedule__c, Opportunity.name FROM OpportunityLineItem 
                                         WHERE License_service__c = 1 AND Opportunity.id = 
            :System.currentPageReference().getParameters().get('id')];
     }
        
List<OpportunityLineItem> OppsSponsor = [SELECT id, ServiceDate, Opportunity.name FROM OpportunityLineItem 
                                         WHERE Sponsorship_Service__c = 1 AND Opportunity.id = 
            :System.currentPageReference().getParameters().get('id')];
    
     
    public integer getSponsorRowNumber() {
        if (OppsSponsor.size() >= 1) 
                 return OppsSponsor.size() - 1;
        else
            return 0;
        }
    
    public list <OpportunityLineItem> getSponsorServicelist () {
        return [SELECT id, ServiceDate, Sponsorship_Service__c, PricebookEntry.Product2.Quote_service_group__c, PricebookEntry.Product2.Quote_service_schedule__c, Opportunity.name FROM OpportunityLineItem 
                                         WHERE Sponsorship_Service__c = 1 AND Opportunity.id = 
            :System.currentPageReference().getParameters().get('id')];
     }
}

Many thanks,