Pivot Tables

[Maureen B]

I have a data source that has four columns of data that are all similar. I
want to create one pivot table that would count the items in each column and
provide me with a number for each of the variables. An example of the data
is below.

PR PS PV ST
e m e m
m e e e
e e e e
e m e e

I want to know how many e's are in each column. When I try to do this in
one pivot table it provides the same answer for each column. I have done
this in four separate tables but would like to have them al in one. How can
this be done?

 

[Eduardo]

Hi,
your information is in columns A B C and D
in F1 enter PR, in G1 PS, in H1 PV in I1 ST, then in E2 enter e and in F2
enter

=COUNTIF(A2:A5,$E$2)

copy this formula to the right

 

[Maureen B]

I did this and it works but I would like to be able to do this in a pivot
table versus creating a separate table with the formula.

 

[Eduardo]

Hi,
you will not be able to do a pivot table and get the results you are looking
for because your e are data and the pivot table can count or sum data, you
cannot say to count only the e because e and m are the same for the Pivot

 

[Jim Thomlinson]

To do what you want you need to transform your source data to a paired value
orientation

This That
PR e
PR m
PS e
PR m
PR e
PR m

At that point it becomes failry easy to get your count of e's.