Hi Debra,

Thanks for your replay.

Yes, I had thought of that. I guess the drawback is that it isn't dynamic,
from what I can tell. I would have to paste values only, correct?

I assume that I cannot name subtotals (only) in a pivot table? I've looked
all over (including your excellent site), but can't come up with a definitive
answer.
--
Thanks!

Dee


"Debra Dalgleish" wrote:

You could make a copy of the first pivot table, and show only the data
that you need.
Then, use GetPivotData formulas to extract the data. There's information
in Excel's Help, and he

http://www.contextures.com/xlPivot06.html

dee wrote:
Hi,

I have one data list that includes name of client, city (could be multiple),
Category, and Budget.

I have created a pivot table that displays my totals per client with
breakdown of information that I need, including sub-totals for each client.

Problem: I have another "report' that includes total Budget per client.

I have tried using DSUM on both the original data table and also on the
pivot table, but need to keep referencing the same titles and then changing
criteria for each client, so very long and tedious.

I tried to use a SUMIF that referenced the pivot table instead, but to be
effective, would have to refer to the Subtotals ONLY. If I try to name only
subtotals, it doesn't seem to work. I hide the details, select the subtotals
and name them, but, of course, this doesn't work when details are redisplayed.

Question 1:
Which is the best method.

Question 2:
How can I name only subtotals in a pivot table

Any help would be greatly appreciated.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html