Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't get Grand Totals (rows) to appear
I have a standard pivot table I've created but it only shows the Grand Total
for columns. I've made sure the Grand Totals for Rows is checked in the pivot table options, but it still doesn't appear. Is this a bug or can someone suggest a solution? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't get Grand Totals (rows) to appear
Does all the numeric data that you are trying to sum originate from the same Column of your Source Data? Pivot Tables will not automatically sum numbers originating from different columns of your source data. For example, if your data consists of One column of Salespersons' names, a column of dates and a column of sale amounts, you could drop the names to the column fields area of the pivot table, the dates to the rows area, and the amounts to the data items area, and the rows and columns would automatically sum. However, if your source data has a separate column for each date and you drag all of the dates into the pivot table data item area, no grand total will be created for your rows of data, unless you drag an additional dimension into the column fields area, such as "geographical region" or "product class." If you want to sum numbers from separate columns of your source data you need to create a formula field in the pivot table, e.g. Jan + Feb + Mar -- CaptainQuattro ------------------------------------------------------------------------ CaptainQuattro's Profile: http://www.excelforum.com/member.php...o&userid=32763 View this thread: http://www.excelforum.com/showthread...hreadid=544899 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rows & Columns in Excel | Excel Worksheet Functions | |||
Automatically inserting rows | Excel Worksheet Functions | |||
Hiding Rows if the linked rows are blank | Excel Discussion (Misc queries) | |||
Insert rows | Excel Worksheet Functions | |||
flexible paste rows function that inserts the right number of rows | Excel Discussion (Misc queries) |