Pivot Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm working with a Pivot Table and would like to count
the number of times specific text such as a "P" or "O" is
in a column.

The Microsoft help guide ("Pivot Tables 101") states the
following:

A "Data field" in a Pivot Table "contains values to be
summarized. For example, Sum of Sales is a data field.
For most types of source data you can choose how to
summarize data (for example, by sum, average, or count).
A data field usually summarizes numbers, but it can also
summarize text. For example, you can count the number of
times a specific text entry (such as Yes or No) appears
in a field.

ANYBODY KNOW HOW TO DO THIS?
 
Drag the field to the row area.
Drag another copy of the field to the data area of the pivot table,
where it should appear as Count of Item.
 
Back
Top