Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All I have the following pivot table (without the red color one).
Employee | Appointment Date | Average | |||||
| 06-14-2021 | 06-15-2022 | 06-16-2023 | 06-17-2024 | 06-18-2025 | and so on | ||
| Avg: 3.33 | Avg: 3.35 | Avg: 3.16 | Avg: 2.66 | Avg: 2.5 | Avg: 3.16 | ||
| A | 4 | 1 | 5 | 4 | 4 | 4 | |
| B | 3 | - | 4 | 3 | 3 | 4 | |
| D | 5 | 5 | 6 | 5 | - | - | |
| E | 3 | 5 | - | 4 | 4 | - | |
| F | - | 4 | - | - | 4 | 5 | |
| G | 5 | 6 | 4 | - | - | 6 |
Now I need as the Average value in each column as displayed in the image. It should also alter the result accordingly when I select employee(s).
Can anybody help me out to achieve this?
Thanks in Advance.
Madhab Sikder
Glad I could be of help.