Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
use num(trim(AnchorIndex)) in dimension and give the label as AnchorIndex
hope this help
What are all the dimensions in the straight table other than AnchorIndex? If AddPower is also a dimension, does one AnchorIndex have multiple AddPowers?
Hi,
All the fields in the image are dimensions.
All the fields will have a relation with other fields.
Regards
Venkat
Why don't you use Pivot table instead of Straight table? It will group the values and show you a single value.
Regards,
Jagan.
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
I am currently trying to do a very similar thing. Any luck using distinct values for a dimension?
HI ,
I think you need to use some Aggregate function in the expression .
Regards
Yusuf