I'm new to SAP BPC EPM reports. My client has a requirement, where he want to create a new report and in that he wants to implement drop down on NAME(which is user), and based on the user selected from drop down, we should see data for the department related to that particular selected user only.
For example consider below data from screenshot.
If i select NAME = USER1, then i should see data of Operations only (operation is department).
and if i select different USER2, then i should see data related to the department of USER2.
So, i need help in implementing this drop down on field 'NAME' and based on the selection, i should get it's related department data.
I appreciate your patience for reading this.