| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table problem
most effective and simple would be to have source data update like
this Name Category Value Joe B 50 Sue C 75 Sue D 25 Sam B 50 .... then it would be a breeze to see the totals in the pivot table, you just need to switch on "grand totals" (or sub totals depending on the table complexity) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem inserting calculated pivot fields into Pivot Table (2007) | Excel Discussion (Misc queries) | |||
| Pivot Table in Excel 2007 : Problem with % in Table | Excel Discussion (Misc queries) | |||
| Pivot Table Problem | Excel Discussion (Misc queries) | |||
| Pivot table problem... | Excel Worksheet Functions | |||
| Will a Pivot Table Help with my problem? | Excel Discussion (Misc queries) | |||
Threaded Mode
