How to add Indentation to the specific dimension values in a Pivot Table

[vish123]

Hi Team,

I need to add a some white space to the specific dimension values and using below formula to achieve the same but its not working.

=if(Metric='F2F',

repeat(chr(32),10) & 'F2F', Metric)

In case of the other characters its working. Please suggest.

[vish123 · Accepted solution]

Hi Team,

Sorry , I have tried with chr(160) and its working. Thanks for your support