Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pivot Table - Average of counts
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
weighted average in pivot table | Excel Discussion (Misc queries) | |||
Change Data In Pivot Table | New Users to Excel | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) | |||
How to Get Sum of the Average in Pivot Table? | Excel Discussion (Misc queries) |