Compare the values of different rows for particular dimension and show the status

[snehatopre]

So in this image you can see there are two practitioner_id. And the both Practitioner_id are having common Manufacturer and Drug name and the third column is showing matched with which practitioner. So here we can see the third column is published with Matched and 56834216, the practitioner id with which it is matching.

So in third column i want show that both the practitioner's are having matching Manufacturer and drug name.

Can it be possible?

[vinieme12]

try with Autonumber(Manufacturer&Drug)  this will create a unique number for each manufacturer

in load script create a key as

PractitionerID,

Manufacturer,

Drug,

PractitionerID&'_'& Autonumber(Manufacturer&Drug)  as Common

[kamal_sanguri]

Pls see this, may be this is what you are looking for.

[snehatopre]

Its is working. But not as I want. See the image below:

So here result is matching with all the practitioner in the application. But what I want is, it should match with Practitioner current selected set of Practitioner's which are there in this chart.

I am having a question that, can we calculate this Result field in the chart only.

Is there any way for doing that?

[vinieme12]

You cannot have a Result field like this because you may have n number of Manufacturer and Drug name repeat for multiple practioners. Which is why i suggested to only keep the Key column which you can select on

can you post some sample(dummy) data

[kamal_sanguri]

At the chart level..