| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
pivot table returning a "value in the data items"
I want to use a pivot table to return values in the data items area. I have
several fields that are a Y or N data and Date Data. I do not want to sum or count the data I want the specific data Y/N or Dates there. Is this possible? If so it will save me many hours of work. |
|
#2
|
|||
|
|||
|
You can show dates in the data area -- they may appear as numbers at
first, but you can format them as dates (FormatCells) For the Y/N field, you could use 0 and 1 instead, and show those in the data area. MissCrafty1 wrote: I want to use a pivot table to return values in the data items area. I have several fields that are a Y or N data and Date Data. I do not want to sum or count the data I want the specific data Y/N or Dates there. Is this possible? If so it will save me many hours of work. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining two data sources in a Pivot table. | Excel Discussion (Misc queries) | |||
| Pivot Table Data Field Query | Excel Worksheet Functions | |||
| How do I get a pivot table to sort based on the data items sectio. | Excel Worksheet Functions | |||
| Pivot Table Data | Excel Worksheet Functions | |||
| Pivot Table Auto Update Data Source? | Excel Worksheet Functions | |||
Linear Mode
