Skip to Main Content

Filtering an answer base on a a drill-down answer

HanncapJul 3 2014


I'm having a problem filtering a report.

The report has a prompt where I can choose the client (edit box).

The report also has two answers.

  • Answer 1

Where I can drill-down by the branch and see the clients and clients account on that branch.

  • Answer 2

This answer shows the accounts in more detail and only appears when the prompt client is filled.

To have interaction with both answers I have done:

  • Answer 1

I have done the Navigate.

Column Properties -> Column Format

And at Value Interaction, I selected:

    Type: Navigate

    Target: Answer 2

  • Answer 2

Filter on saved request, where I selected the answer 1 and the field account

My problem is that a client could have more than one branch, so when I choose the client (on the prompt), it will appear the accounts and doesn’t filter by the branch that I have done the drill-down.

How can I filter the Answer 2 based on the Answer 1 drill-down result?

Best Regards,

Post Details
Locked due to inactivity on Jul 31 2014
Added on Jul 3 2014