pivot table with multiple instances

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

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



J wrote:
>
> 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

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


--
Regards

Roger Govier



J wrote:
> 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

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


--
Regards

Roger Govier



Roger Govier wrote:
> 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
>
>
>
> J wrote:
>> 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