Display text string in a calculated dimension

[lessassy]

Hello everyone,

When it's about dimension i know how to use the set analysis (count, sum, Aggr).

But i want to use the calculate dimension to display text string.

I want to display text string in a straight table but i tried everything.

Like for Business Assignement Leader, i tried only function to display all the name but i can't get it right for some reason.

Anyone have a set analysis that would work correctly ?

Thank you

[vishsaggi]

Did you try like below in calculated dimension

= 'Business Assignment Leader'

[lessassy]

It doesn't work either.

This full name is a field in one of my table

[vishsaggi]

Can you show some sample data with your expected output?  I quite did not understand what you are looking for then?