Is there any way to show all the values in millions even if data is in thousands, the default million formattings will show the values less that a million in the regular format
Hi datanerd,
You can use custom currency format.
Just devide your value by 1 000 000 in the formula and add Symbol M.
Below is an example with thousands.
Best regards,
Angelina