Sorry for the confusion.
A simple example will be as follows:
Employee ID Name SSN Salary
001111 Emily Kale 545429234 $54,000
001112 John Martin 212755484 $82,000
001113 Samuel Lee 854212521 $74,000
001114 John Martin 851214444 $39,000
I want to create a histogram to show each employee's salary, so I choose "Name" as dimension, and "Salary" as mesure, then the chart I get is 3 names, John Martin's salary become $121,000 ($82,000+$39,000). Is there a way that I can still see four employees with their respective salary ? I prefer not to change the dimension "Name" because I need it to be displayed.
Thanks so much for your help.
How then will you know which John is which?
or maybe you will, but somebody looking at the graph will be confused.
You can add a prefix or suffix like:
EmployeeID &Name as Name
RecNo()&Name as Name
in the load script but that will assign EmployeeID or record number to each name.
Do they have a second name?
Maybe adding additional information at the source of your data will help?
Otherwise, I do not see a way to convict QV that John Martin<>John Martin
As explained by Robert, it will be confusing for any user or even we as a developer to differentiate between two occurrence of John Martin in chart even if it is shown in two separate rows.
So, it is mandatory to provide additional info about the Name field that will differentiate John Martin.
In your case, it will be Emp ID which can differentiate the two John Martin.
Rather going on for finding solution for this, instead you should make understand your Functional or User abt this consequence.