Tammy Levasseur
New Member
- Joined
- Oct 12, 2016
- Messages
- 5
I have a spreadsheet with data and I want to show the average of the data by discipline (which is doable) but in the Total I want to sum the average data. Is this possible. When I add the Total to the Pivot it provides the average of the data. Below is a sample: CHK, DES and ENG are disciplines and the data is an average of each discipline on the 3533001.2521 row I would like a total of the averaged data. Let me know if there are any solution. I've read about power pivot. Not sure if that is what is required.
<tbody>
</tbody>
3533001.2521 | 22 | 33 | 67 | 41 |
CHK | 1 | 4 | 3 | 3 |
DES | 20 | 20 | 53 | 31 |
ENG | 1 | 9 | 11 | 7 |
<tbody>
</tbody>