Show Value in Scatter Chart

[#1]

Hi Friends,

I have created a scatter chart based on EmployeeId and requirement is to show sum(Target),But on data points I need to show Employee name instead of EmplyeeId. I used Show Value option by creating third expression but it didnt work.I have attached the sample application,if anyone has any idea please share with me.

Regards

Bhawna    

[Gysbert_Wassenaar · Accepted solution]

Use the dual function in a calculated dimension: dual(Employee, EmployeeID). See attached qvw.

[#3]

Thanks Gysbert ,it works like magic...