Pivot Table question

Giganews Newsgroups
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:
Fruits:
Apples
Oranges
Pears
Oranges
Pears
Oranges
Pears
Apples
Apples
Apples

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.

Scott

Replies