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.
Where I can drill-down by the branch and see the clients and clients account on that branch.
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:
I have done the Navigate.
Column Properties -> Column Format
And at Value Interaction, I selected:
Target: 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 all the client accounts and doesn’t filter by the branch selected on the drill-down.
How can I filter the Answer 2 based on the Answer 1 drill-down result?