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.

Sorry, fixed a typo:

"ajholloway" wrote:

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,
D. 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.

Anyone have any help here? I really am at the end of my rope.

Thanks,

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.

ajholloway wrote:
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.


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com

Thanks for your help.

"Debra Dalgleish" wrote:

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.