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
Bookmarks