Row Totals in Pivot tables

[kosciosco]

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

[Miguel Zapico]

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
>
>

[kosciosco]

Thanks - that was spot on