Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pls Hlp - Pivot Table or DSum???
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. -- Thanks! Dee |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
How do I sort pivot table data outside a pivot table | Excel Worksheet Functions | |||
DSUM when database is part of a pivot table | Excel Worksheet Functions | |||
Pivot table and Dsum security | Excel Worksheet Functions | |||
How do I create a pivot table if the pivot table icon or menu ite. | Charts and Charting in Excel |