Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help with pivot table
My ignorance of pivot tables is causing me grief, I'd appreciate some help.
At least I think I should be using a pivot table. On a worksheet I have a number of rows with 3 columns (Date, Name and Activity). I'd like to present that data in a pivot table with Name as the Row Heading, Date for the Column heading and Activity as the data. The wizard will only let me put a "Count of Activity" or "Sum of Activity" in the data field. How do I get it to just put the Activity code there, not a count or sum or any other aggregate. Thanks in advance for any help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
updating pivot table to include additional rows | Excel Discussion (Misc queries) | |||
Change Data In Pivot Table | New Users to Excel | |||
Pivot Table - Multiple consolidation Range | Excel Worksheet Functions | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) |