I have a large data table which contains a list of invoices and for each invoice a job number, as well as lots of other information.

I want to set up a pivot table to create list of job numbers with the total revenue for each i.e. it will add together the invoices. I will then use this table to build other pivot tables from.

The problem I have is I am setting up the pivot table this way:

Job No. Acct Service

Each time I add a new column I get row totals, so when I add account I get the total for the job no. I don't want this, I just want a data table!

Can anyone help me stop it doing this?

Thanks

Simon