Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Row Totals in Pivot tables
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
#REF in Sheets that refer to Pivot Tables | Excel Discussion (Misc queries) | |||
Pivot Tables - Grand Totals | Excel Discussion (Misc queries) | |||
Dynamically changing several pivot tables at once | Excel Discussion (Misc queries) | |||
Macro for Pivot Tables | Excel Discussion (Misc queries) | |||
Calculations using totals generated in Pivot Tables | Excel Discussion (Misc queries) |