Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table column total not working (Excel 2007)
Hello -
My first post to this group; thanks in advance for the help. I'm a fairly experienced Excel user, but can't figure out why the pivot table in the sheet at the link below will not display column totals (and thus % of column values, which I want to use in a chart). I've tried to simplify the sheet as much as possible from the version I'm actually working on. Link to sheet: http://www.mediafire.com/?sharekey=0...75f6 e8ebb871 Any help is much appreciated! John |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table column total not working (Excel 2007)
Excel 2007 Pivot Table
Page Field, count items http://www.mediafire.com/file/uzjgzn...07_24_09a.xlsx |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table column total not working (Excel 2007)
Hi John,
I've looked at your file and am a little puzzled by something, You are summing columns such AZtot but I can't see these columns in the source data; in fact there are more fields listed in the pivot table field list than are in your source data: 'Source Data'!$A$1:$U$90 Is this some other feature of pivot tables I'm not aware of? Where and what is AZtot? Thanks, Jay __ scrimshander wrote: Hello - My first post to this group; thanks in advance for the help. I'm a fairly experienced Excel user, but can't figure out why the pivot table in the sheet at the link below will not display column totals (and thus % of column values, which I want to use in a chart). I've tried to simplify the sheet as much as possible from the version I'm actually working on. Link to sheet: http://www.mediafire.com/?sharekey=0...75f6 e8ebb871 Any help is much appreciated! John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I sub-total 2 of 4items in a column in a pivot table? | Excel Discussion (Misc queries) | |||
Total Column in Pivot Table | Excel Discussion (Misc queries) | |||
Working Excel 2007 pivot table, want just text to show on the pivo | Excel Discussion (Misc queries) | |||
Sub-Total Column in a pivot table | Excel Discussion (Misc queries) | |||
PIVOT TABLE - GRAND TOTAL COLUMN | New Users to Excel |