Filter data in 3 levels.

[udix]

Hi everyone,

i'm working on a test plan, & instead of making 3 different test plans documents for 3 diffrent levls of testing i thought i could just use excel with one document and use filter function to show the test levels.

an example:
in the attached workbook i have 10 tests & results.

i want to filter the document to 3 stages.
A - all the 100% of the document data is shown.
B - just 40% (say 1, 8, 9) of the data that i choose will be show.
C - just 20% (say 8, 9)of the data that i choose will be show.

notes:
C will be shown when choosing B &/or A.
B will be shown when choosing A.

i hope that's clear enough, attaching a workbook to the post.

Thanks!