| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
function defaults change in Pivot Table..why?
I was recently working in my pivot table and had something happened that
doesn't make a lot of sense to me so I'm asking for some assistance. Usually, when I drag a field on to my Pivot Table in the DATA section it defaults to the sum function with a number field. It also defaults to a count function when I drag a field that has text in it. Recently, I got a pivot table that default a number field to the count function. Can anyone explain why the default has changed on this particular Pivot Table? Any asistance would be greatly appreciated ! Thanks! Tim |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count function in pivot table | Excel Discussion (Misc queries) | |||
| Pivot table keeps dupping to another linked pivot table | Excel Discussion (Misc queries) | |||
| Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) | |||
| Macro to change a Pivot Table | Excel Discussion (Misc queries) | |||
| Pivot Table Problems | Excel Discussion (Misc queries) | |||
Threaded Mode
