I am making a spreadsheet that displays test times for various software tests
across several sw builds. It looks like this:
Build A runs tests 1-100
Build B runs tests 101-200
Build C runs tests 201-300
Build D runs tests 301-400
All of the data is in my data worksheet.
I build the pivot, then go to the filter button for build and select A, C,
B. Then I go to the filter button for test # and I see 1-400. Is there some
way to actively filter the options for test # so that I do not see 201-300
when I don't select C? The solution would have to be active in that when a
person makes a different selection, the test # should only display those
tests that were run in the given build.