Only show one value in frontend

[Theo_Westseit]

Hello,

i have a table, which contains multiple fields, but at the frontend, i only want to show one certain field.
The source data looks like this:

Header

Amber

Tom

Peter

at the frontend, i want it to look like this (only show Amber):

Header

Amber

can you guys help me?

[Vegar · Accepted solution]

I'm not sure what you are trying to do, but the expression below will let your dimension to only show 'Amber' values.

If (Header='Amber', Header, null())

[vinieme12]

" i only want to show one certain field"

You haven't specified based on what condition ?  Why Amber and not Tom or Peter ??

Do you only want to

1) show the first value ??

2) show value with most characters ??

3) Any other specific criteria ??

The answer changes for each use case , please add some context 

[Theo_Westseit]

Thats what i was looking for! Thanks so much.