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

 

[Guest]

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]

Thanks - that was spot o