Hi,
I applied a user filter for my report so that each user can see the products that they have access to. I have to product list as a quick filter showing relative values only. When I switch users, the default value becomes like (Product 1) if the user has no access to that product.
How can I set the default value to the first value of the product list dynamically based on which user is logged in? I don't want a user be able to see the product names that he/she has no access to even all chart is empty.
Any suggestions?
Thanks
Hi,
I applied the user filter already. My problem is that: when I switch users, the default filter value (product in this case) set by the other user is shown in the filter list even if the current user has no access to that product. For example, user 1 set filter value to product1, when I switch to user2, who has no access to product1, user2 still sees (product1) in the filter list as default filter value though no value is returned. I don't want user2 to see (product1) in the list.
Any thoughts?
Thanks
