Hi everyone.
I've got a column table reporting all the years the employee worked with our company. I would like to use it to filter some pivot tables so that they will return data pertaining to just one selected year, but unfortunately Excel won't let me choose singular years and will only present me the various options the way the data was originally entered in the column.
Is there any way to do what I'm trying to do? I'm using excel 2007.
https://imgur.com/hg5XVJQ
https://imgur.com/CdMMLnm
I've got a column table reporting all the years the employee worked with our company. I would like to use it to filter some pivot tables so that they will return data pertaining to just one selected year, but unfortunately Excel won't let me choose singular years and will only present me the various options the way the data was originally entered in the column.
Is there any way to do what I'm trying to do? I'm using excel 2007.
https://imgur.com/hg5XVJQ
https://imgur.com/CdMMLnm