I am using a map to show data of number of customers on a geo map.
this uses a count (customer) function.
it works however...is there a way of formatting the number to simple?
its showing up example as 150.75k
Could you create a Master Item / Measure first ?
... and in the measure definition use the num() function to format as money / integer etc... ?
ex: num(sum(Sales) * count(OrderID),'#,##0')
Thank you xx
done, but no need for the master item
amended your code and it worked
Retrieving data ...