Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table problem
I have a pivot table with Names in Column A. Columns B, C and D contain data
as follows: A B C D Joe 50 Sue 75 25 Sam 25 Tom 30 Fred 20 How do I make my pivot table total each row? (Joe = 50, Sue = 100, etc) I don't care if a new column is added or if B, C and D are combined in 1 column. I need those totals for my Pivot Chart. |
#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) |
Reply |
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) |