I currently have a dashboard with a table that has an account. This account can have multiple users that touch the account so the data reflects that. I also have a table next to it that lists the users and some other info. I am trying to make it so that when a user clicks on a username in the table on the right, the table on the left will show all detail for any user that has touched it as long as the one i selected on the right also touched it.
Example:
Account
| Account | Date | User |
|---|
| k001 | 1/1/2012 | Mike |
| k001 | 1/2/2012 | Shawn |
| k001 | 1/3/2012 | Steve |
| k002 | 1/4/2012 | Dave |
| k002 | 1/4/2012 | Nigel |
If i select mike from the right table, i want all the records for account k001 to show up.
I currently have this
Count({$<AccountNumber=P({1<InterventionActivityUser_UnvUserID={$(='Mike')}>}AccountNumber)>}AccountNumber)
It works, but i need to not have it be hardcoded. I have played around a bunch and i hope this is something simple. Any help would be awesome!
