| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum in pivot tabels
Hi,
I am experincing a problem when I am draging and dropping to a pivottable. I would like to have "Sum of" but I get "Number of". When you drag and drop 15 times it takes a longe time to change. Is there a way to change all the "Number of" to "Sum of". Chris |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sum in pivot tabels
Make sure that all the data for that button is actually stored as numbers
and blanks are filled with zeros. Then the default will be Sum of. -- Regards, Tom Ogilvy "CLUPE" wrote in message om... Hi, I am experincing a problem when I am draging and dropping to a pivottable. I would like to have "Sum of" but I get "Number of". When you drag and drop 15 times it takes a longe time to change. Is there a way to change all the "Number of" to "Sum of". Chris |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data tabels with charts | Charts and Charting in Excel | |||
| Konsolidating tabels on diffrent sheets in one sheets | Excel Worksheet Functions | |||
| Charts from Pivot Tabels without Scroll Down Bar | Charts and Charting in Excel | |||
| how do you make tabels | Charts and Charting in Excel | |||
| Tabels and calculation methods | Excel Programming | |||
Linear Mode
