Hi, I'm wondering if I can have what I need in a single pivot table?
Let's say this is the input table - players scoring against different teams from various conferences:
<tbody>
</tbody>
etc
The real table has much more data than this. I would like to have a single pivot table which averages points in columns per different criteria like so:
<tbody>
</tbody>
If I use columns, then the second column becomes a subgroup of the first one and I don't want that. Can you point me to the possible answer. Right now I have multiple pivot tables and then paste results from 1 column next to the other pivot table but that is quite awkward. Thanks
Let's say this is the input table - players scoring against different teams from various conferences:
name | vs team | vs conf | pts |
player1 | team1 | east | 10 |
player1 | team1 | west | 40 |
player1 | team2 | east | 5 |
player1 | team2 | west | 25 |
<tbody>
</tbody>
etc
The real table has much more data than this. I would like to have a single pivot table which averages points in columns per different criteria like so:
Name | Avg points total | Avg vs team1 | Avg vs Team2 | Avg vs East | Avg vs West |
player1 | 20 | 25 | 15 | 7.5 | 22.5 |
<tbody>
</tbody>
If I use columns, then the second column becomes a subgroup of the first one and I don't want that. Can you point me to the possible answer. Right now I have multiple pivot tables and then paste results from 1 column next to the other pivot table but that is quite awkward. Thanks