Pivot Table - Hide some subtotals

thejd99

Board Regular
Joined
Mar 19, 2002
Messages
57
My data consists of a listing of magazine articles, the dates they were submitted, the dates they were published, and a calculation of the elapsed time between the dates:

Article-----Mag Title---Publisher---Submission Date---Pub Date--Time
1----------Sprockets-----ABC-------1/1/05--------------2/15/05------6
2----------Sprockets-----ABC------1/15/05--------------2/15/05------4
3----------Widget News--DEF-------1/15/05------------3/15/05------8
etc...

I created a pivot table that subtotals each Publisher & Title, the Pub Date, and the average time:

ABC------Title----------Pub Date------Avg weeks
---------Sprockets------ 2/15/05----------5
---------Gadgets --------2/15/05----------7
--Total ABC ----------- 2/15/05----------6

DEF
etc...

My question is: In the pivot table, the total row for each publisher shows a total for "Pub Date" which doesn't really make sense. I can't figure out how to show the pub date for each publication and not show it on the publisher total line.
 

Some videos you may like

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

thejd99

Board Regular
Joined
Mar 19, 2002
Messages
57
So can I assume since no one replied that this cannot be done? :confused:

Any ideas how to accomplish this by some means other than a pivot table?
 

Watch MrExcel Video

Forum statistics

Threads
1,118,678
Messages
5,573,608
Members
412,539
Latest member
itchy00
Top