Issue while adding prompts to a pivot view of an OTBI

Summary: Not able to add and apply prompts to pivot view of an OTBI analysis

Content (please ensure you mask any confidential information):

The requirement I have is to get the questions from a questionnaire in columns and respective responses as well in rows. Pivot view helps me do that. The next requirement is to have prompts on the responses to this OTBI analysis. For examples, if a question has responses like A, B and C, User should be able to fetch all the records where the questions was answered in A/B/C.

Here is what I have, what I did and what I want.