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.