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


--
kosciosco
------------------------------------------------------------------------
kosciosco's Profile: http://www.excelforum.com/member.php...fo&userid=7068
View this thread: http://www.excelforum.com/showthread...hreadid=550995