Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Sum(DISTINCT [Field D])
or in presentation tab > check Max no show(1)
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.
Hey thanks for your response i dint work
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 |
Hi,
Can you elaborate your problem as are you doing summation or want to pick only value.
Regards
Neetu Singh
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