Pivot table filters not offering text format options like Begins with
I have 3 columns of data, as set of system names, the versions they are at and who’s responsible for them. I create a pivot table counting the number of systems at each version.
I then want to filter to only see the the systems that begin with “PRD”. I select the filter next to the Systems column, Select field=Machine and Filter > By Label, but rather than the text options I expect, like Begins with, Does Not Begins with, but I only see date related filters (Before, After, Between etc).
Likewise Filter > By Value only shows number related filters (Equals, Greater than etc).
I’ve tried making sure that column of data is formatted as Text (in the data and the pivot table) – though I didn’t do this previously when it was working. I’m using Excel Version 16.84 (24041420).
Any suggestions?
I have 3 columns of data, as set of system names, the versions they are at and who’s responsible for them. I create a pivot table counting the number of systems at each version.I then want to filter to only see the the systems that begin with “PRD”. I select the filter next to the Systems column, Select field=Machine and Filter > By Label, but rather than the text options I expect, like Begins with, Does Not Begins with, but I only see date related filters (Before, After, Between etc).Likewise Filter > By Value only shows number related filters (Equals, Greater than etc). I’ve tried making sure that column of data is formatted as Text (in the data and the pivot table) – though I didn’t do this previously when it was working. I’m using Excel Version 16.84 (24041420).Any suggestions? Read More