How to filter field button items in pivot tables

  • Thread starter Thread starter ajholloway
  • Start date Start date
A

ajholloway

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.
 
No, the dropdown lists in the pivot table fields aren't dependent on the
selections in another field. There isn't a setting that will let you
change this behaviour.
 
Back
Top