Pivot Table - Average of counts

D

Dan in NY

Reposting...

I have a table with 3 columns of text where column A maps to multiple values
in col B which maps to multiple values in col C.

e.g.
X Y Z
X Y W
X U V
X T <blank>
S R Q

I'm trying to make a pivot table that shows me:
Col A Col B Count of Col C per Col B:
X Y 2
X U 1
X T 0
S R 1

Summarized by the total count of Col C as well as the Average Count of C per
B. So if there were 1 C for each B, the average would be 1. If each B had 2
Cs, the average would be 2, etc. I can't seem to find a way to show that
subtotal and overall total (so across all of A, the total number of C divided
by the total number of B). I can only average the value, which in this case
returns an error since it's text.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top