If you a Chart and using the Name of the Plant as one of your dimanesion, you can use 'If' condition.
If you want to change the name of the plant from ABS to AAA,
you can use:
=if(Name_of_Plant = 'ABS', 'AAA', Name_of_Plant)
What this will do is whenever the name ABS comes in the report, it will change it to AAA and otherwise it will fetch the data from the field Name_of_Plant.
I hope this might help your query..
Thank you for your responses. I tried to do what you told, but my request did not work.
This is my script
MAPPING LOAD DISTINCT
LDE_VALUE, // DC Code
INT_DESC, //DC Name
If(INT_DESC = 'MANTENO DC', 'YC Kennewick Coldstor DC', INT_DESC) AS DC
upper(trim(INT_TYPE)) = 'PLT';
I want to change the display from 'MANTENO DC' to 'YC Kennewick Coldstor DC'
Thank you so much for your help