Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
row totals in pivot table
Hi, when I look at the pivot table options i see a button to show
grand totals in rows. however, it is not working.any ideas? I am using Excel 2007 Thanks Here is what my pivot looks like. What i am looking for is a column that totals by Evaluation and Prd Line Values Evaluation Prd Line Sum of Stock Value Sum of PO Value Sum of Req Value Sum of Prd Order Row total to go here GENUINE 19 $965,482 $54,239 $0 $0 6 $6,042,343 $94,818 $7,673 $27,190 (blank) $48,338 $105,548 $0 $158 GENUINE Total $7,056,163 $254,605 $7,673 $27,348 NONALIGNED 19 $743,969 $22,829 $0 $0 6 $6,857 $32,006 $5,827 $0 NONALIGNED Total $750,825 $54,836 $5,827 $0 POTENTIAL 19 $1,543,077 $250,657 $19,136 $0 6 $2,322,531 $782,234 $156,283 $28,979 (blank) $99,848 $60,000 $0 $0 POTENTIAL Total $3,965,456 $1,092,890 $175,419 $28,979 NEED TO EVAL 19 $1,673,071 $908,890 $113,120 $5,594 6 $4,697,716 $2,642,633 $963,008 $205,885 (blank) $1,008,476 $266,600 $7,484 $3,067 NEED TO EVAL Total $7,379,264 $3,818,123 $1,083,613 $214,546 Grand Total $19,151,708 $5,220,453 $1,272,531 $270,874 Any ideas |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table totals | Excel Discussion (Misc queries) | |||
Pivot Table Row Totals | Excel Discussion (Misc queries) | |||
Pivot Table Chart - With Pivot Table Totals | Charts and Charting in Excel | |||
Pivot Table - Sub totals | Excel Discussion (Misc queries) | |||
Totals For a Pivot Table?? | Excel Discussion (Misc queries) |