Jump to content

I have a project where i need to show the amount in Thousand as K, Millions as M, and Billions as B in different segments such as Chart, Pivot Table

Recommended Posts

On 8/4/2022 at 1:58 AM, futurist said:

On the code, simply replace:

const cells = document.querySelectorAll(".cbResultSetTableCellNumberDate");


const cells = document.querySelectorAll(" .cbResultSetTableCellNumberDate:nth-child(3)");

and 2.

const cells2 = document.querySelectorAll(".cbResultSetTotalsDataCellNumberDate");


const cells2 = document.querySelectorAll(".cbResultSetTotalsDataCellNumberDate:nth-child(3)");


and change the 3 with the order of the column it comes in. best thing to do is play around with this, add or subtract 1 until you get the desired column




It is working fine however we have deployed 4 pivot table in one web page and in 1 of the pivot table we have data on column 2 position and in another table we have data in column 3 position, so when we update the header & footer in one table then it is reflecting on another table automatically.



Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...