I have several Team Leaders sharing one QV report. The report contains KPIs of Team Members, e.g. "Number of Sales" as per Team Member.
Task: 1.) Every Team Leader shall see the real names of his Team Members. 2.) Names of Team Members of other teams shall be visible anonymised only. KPIs are visible normaly. 3.) A Team Leader deputising another Team Leader, shall see the real Team Member names of the deputised team additionally.
This is easy, e.g. you can use a calculated dimension such as
Problem: Whenever a team member is being selected (in the chart of a list box), the original Team_Member_Name is being displayed in the selection status. That's because field Team_Member_Name is part of the calculated dimension formula.
Target: 1.) When a real Team_Member_Name is being selected, real Team Member name shall be displayed in the selection status box. 2.) When an anomyised Team_Member_Name is being selected, anomyised Team Member name shall be displayed in the selection status box.