How to display only selected fields within dimension

[jacek2703]

Hello there,

how to show only selected fields in my table with no using filter panel and alternate states?

Field: = [T1 Partner Name]

Any idea? Thanks for any help!

 

[GaryGiles · Accepted solution]

Use the aggr() and replace the values with the desired values:

Aggr(Only({$<[T1 Partner Name]={'Techn. . . .','AMTE. . . .','Ronlig. . . .'}>} [T1 Partner Name]), [T1 Partner Name])