Hi there,
I have a table as shown below, and I would like to calculate the average by dimension starting from the beginning of the earliest financial year to the last completed financial year (excluding the current financial year). An example is provided below.
I would greatly appreciate your assistance with this.
Thank you!
| Product Faults |
FY20 |
FY21 |
FY22 |
FY23 |
3 Year Avg. (excl FY23) |
| Desktop |
10 |
20 |
17 |
1 |
16 |
| Laptop |
45 |
29 |
18 |
11 |
31 |
| Phones |
76 |
70 |
29 |
14 |
58 |
