|Subject:||Pivot Table question|
|Posted by:||Scott Riddle (saridd…@lisco.com)|
|Date:||22 Oct 2003|
I have a 1 column list of items like this:
How do I get a pivot table to give me the count of each fruit along
with the number of fruits listed? I change the layout of my pivot
table to have Fruits shown for ROW and Count of Fruits for the DATA.
How do I now get it to show me the count of different fruits? I am
looking for the number 3. It shows me each of the fruits but no count
as to how many different types. Do I need to enter a formula somewhere
or can it be formated somehow into the pivot table? I want to be able
to do this in the pivot table and not a seperate formula in a cell.