dynamic column selection based on login in BI Answers
Hi
I have a dimension with manager level 1 to 10, based on the user login, I want to display the table with the column (level 1 or level n) dynamically ( ex: if the user is in manager level n, display column level n with other data in the table). P.S. there are more than 10000+ users, so I can't customize each user.
can you please let me know if this is possible and how to do it?
Thanks a lot,