Guinaba
Board Regular
- Joined
- Sep 19, 2018
- Messages
- 234
- Office Version
- 2016
- Platform
- Windows
Hi guys,
I have this Pivot Table, created from PowerPivot, where I'd like to see in the Grand Total field the average of all the dates. Not sure the reason but the Value Field Settings is disable, so I cannot summarize the Grand Total column. I manually created the Total AVG just to show the correct values.
Any idea how can I have the use Total AVG using the Pivot Table, reminding that it is from the data model (PowerPivot).
I have this Pivot Table, created from PowerPivot, where I'd like to see in the Grand Total field the average of all the dates. Not sure the reason but the Value Field Settings is disable, so I cannot summarize the Grand Total column. I manually created the Total AVG just to show the correct values.
Any idea how can I have the use Total AVG using the Pivot Table, reminding that it is from the data model (PowerPivot).
| Correct AVG | ||||||||||||
| Customer | 4/11/2024 | 11/11/2024 | 18/11/2024 | 25/11/2024 | 2/12/2024 | 9/12/2024 | 16/12/2024 | 23/12/2024 | 30/12/2024 | Grand Total | Total Average | |
| Customer A | 100% | 100% | 100% | 100% | ||||||||
| Customer B | 100% | 100% | 100% | |||||||||
| Customer C | 52% | 52% | 56% | 42% | 21% | 61% | 23% | 34% | 44% | |||
| Customer D | 42% | -49% | -6% | 18% | 21% | 53% | -22% | 30% | -39% | 18% | 5% | |
| Customer E | -12% | -20% | 33% | 49% | 12% | 38% | 42% | -45% | -85% | 17% | 1% | |
| Customer F | 29% | 56% | 75% | -8% | -36% | -26% | -25% | -52% | -131% | 12% | -13% |
