Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
2007 Pivot Tables
Can someone advise if it is possible change something in Excel 2007.
Whenever I pivot any data the values fields ALWAYS comes up as count instead of SUM. 99 times out of a 100 I need it to be SUM. I'm currently having to go into each set of data and change to SUM each time. Anyone know if there is a way to get it to automatically come up as SUM? Or is the issue with the data not the pivot functions, however the data does SUM when manually changed. Many thanks in advance for any help provided Tom |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2007 pivot tables in 2003 | Excel Discussion (Misc queries) | |||
Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
Excel 2007 Pivot tables | Excel Worksheet Functions | |||
Macros / VBA / Pivot Tables in 2003 & 2007 | Setting up and Configuration of Excel | |||
2007 Beta 2 Pivot Tables | Excel Discussion (Misc queries) |