pivot table - Conditional Filters in a PivotField Excel -

what want do. did paint since otherwise not asking community, here's how think should going.

i have 1 question multiple choices each followed consequential question. real set far more complex, respondents can answer every question if should have answered one, why merely filling blanks merging desired columns 1 not option me.

instead, have tried visualize creating pivottable each question column, , plot result. leads me dirty chart annoying non-answers because of 'impossible' , blank answers.

i filter each response "if first answer a" "filter out data conditional question answer b that's not supposed there" , "if first answer b" "filter out data that's not supposed there".

if know of way around problem, or different solution altogether, feel free lead me in right direction!

thank much,