distinct field values in dimension tab

[#1]

Hi all,

I need to display only distinct fields in the dimension tab of Straight table. All the dimensions should display only distinct field values.

See below image, for AnchorIndex field is having repeated values, how to avoid this.

how is this possible ?

Thanks in advance

Regards

Venkat

[SunilChauhan]

use num(trim(AnchorIndex)) in dimension and give the label as AnchorIndex

hope this help

[jagan]

What are all the dimensions in the straight table other than AnchorIndex?  If AddPower is also a dimension, does one AnchorIndex have multiple AddPowers?

[#4]

Hi,

All the fields in the image are dimensions.

All the fields will have a relation  with other fields.

Regards

Venkat

[jagan]

Why don't you use Pivot table instead of Straight table?  It will group the values and show you a single value.

Regards,

Jagan.

[#6]

I need to export data into a Tab delimited text file. And the major requirement is also display the data in straight table.

Regards

Venkat

[#7]

I am currently trying to do a very similar thing.  Any luck using distinct values for a dimension?

[#8]

HI ,

    I think you need to use some Aggregate function in the expression .

Regards

Yusuf