Create a dimension with a specific string

[#1]

I want to create a dimension which filter the string '10PCMARFINAL' from field [Exposure Type]. I should not use SUM, but when I remove sum, I am getting error. What is the correct syntax?

[Gysbert_Wassenaar]

Try =If(Exposure Type]='10PCMARGINAL', [Exposure Type])

[trdandamudi · Accepted solution]

Give a try with the below: If this doesn't help, then please share a app with sample data and expected output.

=Aggr(Only({<[Exposure Type]={'10PCMARGINAL'}>} [Exposure Type]), Currency,[Discount Curve],[Maturity Bucket].[Trade ID])

Note: you need to list all your dimensions at the end in the above expression.