View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
 
Posts: 1,180
Default Looking for pivot table functionality that shows detail instead of count

Since you want the details of the data instead of the count,
or in other words, the date and the child name instead of a set of 1's,
use sum of Date and format the Pivot Table results with a date format.
For the second Pivot Table, replace C1,C2,C3 in the ChildName column
with the numbers 1,2,3 and use sum of ChildName.
Create a custom format (limited to 3 names):
[=1]"John";[=2]"Tim";"Fred"
and format the second Pivot Table results with this custom format.
If you have more than 3 names, you can use a lookup table,
but this adds complexity.