| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I use a pivot table to present data, not sum or count it.
Here is my problem, I have one database with three fields, Name, Exam, Date
Taken. I want a pivot or other report which shows the names in rows and the exam type in columns. The data section of the report needs to just present the date the exam was taken. The pivot table is perfect except it wants to operate on the data (sum, count, average, etc.) Is there a way to just have it present the data. Or, is there another function that would do that? Rick |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Refreshing Data within a pivot table | Excel Worksheet Functions | |||
| Pivot table Data area show/hide behavior | Excel Discussion (Misc queries) | |||
| Pivot Table Data Field Query | Excel Worksheet Functions | |||
| Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
| Pivot Tables, Help? | Excel Discussion (Misc queries) | |||
Threaded Mode
