To Show Common Values Against One ID

[#1]

Hi  All,

I have the Two dimensions ID and Truck No like

ID          TRUCK No

10            00010

10            00035

10            00045

10            00060

20            00010

20            00045

30            00090

40            00086 

50             0090

I want to show he common values like Id  10 or 20  bothe have some common values i.e 00010 and 00045 show I want to show once  against only ID  10 not show the 20 ID in the Table.

Can any one Please give me idea ??

Regards

Deepak

[tresesco]

So is it like, you want the TRUCK No values to be shown once against the first appearance in ID? If so, may be you can try Not Exists() in the script in Where clause.

[#3]

Hi Tresesco,

Thanks for reply. but I want in only one report to show the common Truck No against One ID.I can n't apply in the script.

Can I do in the front end ??

Regards

Deepak