OTBI Analysis Columns displayed by prompt values

Hi Experts,

We have a balance report that works well. However, we would like to display in it some context based assignment DFF's.

We would like to keep 1 report for each legislation and to display the columns with the dff's based on prompts.

For example: let's say the user selects a Legal Employer Name from the prompts and based on that name the analysis returns only the columns associated with it: in the above example the Disability group column.

Is this possible?

If yes, how?

Thank you in advanced

Marius