Removing the duplicates

[sivarajs]

Hi,

I have table like below

Field A	Field B	Field C	Field D
1	xyz	rec	456
2	xyz	rec	456
3	xyz	rec	456
4	xyz	rec	456
5	xyz	rec	456
6	xyz	rec	456

Its a staight table and am hiding Field A. Because of that it shows all the rest of records. Without Field A it looks the values are repeating.

Field B	Field C	Field D
xyz	rec	456
xyz	rec	456
xyz	rec	456
xyz	rec	456
xyz	rec	456
xyz	rec	456

Is there any workaround to show rest as single record.

Field B	Field C	Field D
xyz	rec	456

Thanks,

Sivaraj

[#2]

Sum(DISTINCT [Field D])

or in presentation tab > check Max no show(1)

[tresesco]

In expression tab put a dummy expression '=1' and hide it in the presentation tab. Now instead of hiding your Field A in the presentation tab, put an enable condition (Dimension tab) as 0 (i.e - 'FALSE' for always).

Hope this gives you an idea.

[sivarajs]

Hey thanks for your response i dint work

[#5]

in straight--

in dimension tab-

select the [Field A]

then check the Enable condition and write its value is 0.

then output like this

see attachment

Field B	Field C	[Field D]
xyz	rec	456

[neetu_singh]

Hi,

Can you elaborate your problem as are you doing summation or want to pick only value.

Regards

Neetu Singh

[sivarajs]

Hi vishwa,

When i enable condition as 0 it showing only single record for entire table.Table has same type of other records as well