pivot table with multiple instances

[Guest]

i'm currently dealing witha pivot table that has column fields and row fields
and is displaying the the "count" of a field. this is displaying numbers
other than 0 and 1 as it should, but i was wondering if there is a way to
somehow display all of the actual values. for example:

apple no tuesday
apple yes monday
apple no wednesday
orange yes thursday
orange yes friday
pear no saturday


making a pivot table of this with the frute as the column field, yes/no as
the row field, and day as the data, you'll notice that orange has 2 yes. how
do i get it to display the days of those yes? ii fpossible, in the pivote
table? any help would be greatly appreciated. thanks

 

[Dave Peterson]

The pivottable data area is for numeric summaries--not text values.

 

[Roger Govier]

Hi assuming the columns are headed Fruit, Yes/No, Day
Drag Fruit to Row ares, then Day to Row area then Yes/No to row area and
drag count of Fruit to Data Area.
Double click on each field in turn, and set Subtotal to None.
From the PT toolbar, select dropdon for Pivot Table>Table>Options and
deslect Grand Total for Rowsand Grand Total for columns.
If you don't want to see the count of Yes and No's for each day, then
right click on the column heading where the PT Toal appears, and hide
the column.
Without the Count column the result will look like

Fruit Day Yes/No
apple monday yes
tuesday no
wednesday no
orange thursday yes
friday yes
pear saturday no

 

[Roger Govier]

That didn't post very well. Try this as HTML

Fruit Day Yes/No
apple monday yes
tuesday no
wednesday no
orange thursday yes
friday yes
pear saturday no