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

You can deactivate the row subtotals going to the field settings (double
click on the header, for example), and selecting none in the subtotals
section.

Hope this helps,
Miguel.

"kosciosco" wrote:


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

Thanks - that was spot on


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