| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Pivot table Data always showing up as "Count"
Hi guys first post here and tried searching for this but couldn't find it. I have a pivot table and whenever I drag and drop in to the Data portion of it, the pivot is always putting it in as a "count" and I am always having to change it to "Sum". Is there a way to change the default way that a pivot handles info droppped into the data box? Thanks in advnace for your help. -n00b  -- qwopzxnm ------------------------------------------------------------------------ qwopzxnm's Profile: http://www.excelforum.com/member.php...o&userid=27557 View this thread: http://www.excelforum.com/showthread...hreadid=470809 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a pivot table from multiple pages of data? | Excel Worksheet Functions | |||
| Combining two data sources in a Pivot table. | Excel Discussion (Misc queries) | |||
| Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
| Need Formula to display pivot table source data | Excel Worksheet Functions | |||
| How can deleted data reappear in a refreshed pivot table in Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
