Forum Discussion
Row and Columns
Hi, thank you for your response
i dont understand value column - and why they have different number
-for example (see diagram below) on the matrix report
i got "ben" appearing all 4 years. therefore he would have 0 attrition
meanwhile "jon" appears 2016 and 2017 not in 2018 , therefore add 1 in the 2018 column
| Name | 2016 | 2017 | 2018 | 2019 |
| ben | a1 | a2 | a3 | a4 |
| jon | a2 | a2 | ||
| mike | a2 | a2 | a3 | |
| peter | a1 | a1 | ||
| ron | a2 | a2 | a3 | |
| potter | a2 | a3 | ||
| harry | a2 | a3 | a4 |
ideally i like to have where i can say 'total attrition for 2018 year is 40, whereas 2017 59
Hi its not working
so i got this now
Name 2016 2017 2018 2019 total
Bob 0 0 0 0 0
Mike 0
tom 0 0 0
jerry 0 0
etc 0 0 0 0
* i know BOB started the comp in 2016 and still in 2019
Mike started 2016 - but has left (blank)
Tom left at 2018 (blank)
***i want to summaries by years - like countif/sumif
for example 2017 attrition is (it needs to add the blank as 1)