Hi,
I have a field that I am displaying value in tooltip in a bar graph. Now, that field may contain more than 1 value associated with it.
How can i have those values showed up in tooltip?
for example:
NPI Specialty Claim_Number
A OD 1
A MD 2
A OD 3
A OD 4
A MD 5
B OD 6
B PD 7
when the bar graph shows each bar for NPI, I have 2 bars in above example. 1 for A and 1 for B. The Specialty is used in tooltip. So far the data had only NPI : Specialty as 1 : 1 relationship so it worked perfectly fine.
New data coming in shows 1 : many for NPI : Specialty. The requirement is that tooltip should display all possible values for NPI.
So the above example should display OD, MD in tooltip for NPI A and should display OD, PD for NPI B.
I am thinking measure may be required to achieve this. If a measure is required that shows OD, MD as a value for a given NPI and then display that measure, then what will be the measure formula?
How can I do this? Thanks! Much appreciated.
