I want to show the values in my chart in Millions even when the values goes to the Thousands, like for "500,000". i want to show it as "0.5 M". can any one help me to achieve this.
Try like: Num(YourExpression/1000000, '#,##0.##M')
Or similar format in the number tab with million division in th expression.
Thankyou tresesco for the idea. i have created a new field in the script by dividing it by 100,000 .
Retrieving data ...