If this has already been answered or easily googled I apologize, not sure what the correct way to word this question.
So in my data table and one of the columns that I want to filter contains numerical data.
Well in my pivot table, I want to create a slicer based on this column, but I don't want the numerical data to be filter options, I want to map these options to string values.
0 = open
1 = closed
2 = won
etc..
Do I have to do this in VBA or create a manual filter for this?
Bookmarks