Display all the values in Million (M) pivot

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

datanerd

Posted 3 years ago·Last reply 2 years ago

4 comments

slosada

·2 years ago

Hi @datanerd,

Great news! I have a quick update about your inquiry. Since this functionality is available in our L2023.11 release as mentioned by the awesome Oleksandr_K, I am going to move this thread into the Product Feedback Forum and mark it as delivered.

Oleksandr_K

·2 years ago · Edited

Hi datanerd, harikm007, Angelina_QBeeQ

We have added a new option "Abbreviate all values" in the product. It has been included since L2023.11

I would be glad to hear your feedback!

harikm007

·3 years ago

Hi datanerd ,

You can also use below script (if you are using pivot2):

const myTarget = {
type: ['value'],
values: [
{
title:[ 'Value to Million'] // put here desired column
}
]
};


widget.transformPivot(myTarget, function(metadata, cell) {
	cell.content = (cell.value/1000000).toFixed(2) + 'M'
});

-Hari

Angelina_QBeeQ

·3 years ago

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