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 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