| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
I am not sure which version you are on but 2002 defaults to count. If you open the pivot table wizard and go to the layout box you should see "count of ####" in the data field. Double click on this and you will get the field dialog box which has the usual average, max min etc HTH -- Alex Delamain ------------------------------------------------------------------------ Alex Delamain's Profile: http://www.excelforum.com/member.php...o&userid=11273 View this thread: http://www.excelforum.com/showthread...hreadid=275628 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding a formula to a pivot table | Excel Discussion (Misc queries) | |||
| Pivot Table services | Excel Discussion (Misc queries) | |||
| How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) | |||
| pivot table multi line chart | Charts and Charting in Excel | |||
| convert excel list to pivot table | Excel Discussion (Misc queries) | |||
Hybrid Mode
