1 of 1 people found this helpful
I have view like below and want append the sales with "LM" now follow the below steps to solve your requirement
Step 1: Right Click on the Measure
Step 2: Select the sales from the fields Drop Down
Step 3: Go to numbers in the Pane and Select the format Numbers Custom
Step 4: after selecting the Number(Custom) your numbers will show value with 2 decimal places and go to custom in the same window
Step 5: Edit the Red arrow mark portion how you want now we need append the Text LM to Sales check the below image how to format
Like this you can format hope this helps kindly mark this answer/correct so that it will help others
Perfect....worked a treat. Many thanks......and so easy in the end.
Thank Naveen......with detail as well.
So easy in the end. Thanks everyone.
No worries, glad to help