You can replicate the filtering functionality you get from a pivot table much more neatly and cleanly in Tableau if you are willing to display it slightly differently. With that said, if you do want the filters to look like pivot table filters, two options that come immediately to mind would be either using cascading checkbox filters or action filters with a hierarchy. Neither one is exactly what you would get out of Excel, but both come somewhat close.
See the attached workbook for some examples. Option 3 is an example of how this could be implemented if you don't care as much about making the filters look like the filters in Excel.
Filter options.twbx 30.8 KB
Thank you so much!
It is working now Perfect answer!