Hi All,
I have this sample data.
On Sheet2 the pivot table.
This is the scenario that I want.
If I only selected "Basic" in the Service Type
I want the second Filter "Job Type" to only show what is available for Basic Services.
Right now, what excel is doing, excel still shows all the job types from both Premium and Basic Services.
Hope you guys can help.
Thanks in advance.
Bookmarks