Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Is it possible to have a pivot table return a non-arithmetic value? What I
have done is create a table of Date, Day, Week, Month, Year, Name 1, Name 2, Name 3, Name 4. The pivot table has the days across the top (Monday, Tuesday, ...), with rows being "weeknum"bers (26, 27, 28), and page controls being month and year. So what I am after is filling in the name fields with peoples names (Mary, Joe, Steve, ...), and having them display in the days of the week that they have scheduled to work. Is this possible? Dave Nelson |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) | |||
pivot table with text | Excel Discussion (Misc queries) | |||
Pivot Table - Wrapping Text | Excel Discussion (Misc queries) | |||
pivot table - keep text wrapped on refresh? | Excel Worksheet Functions |