Get values from multiple selected cells and color specific column
Hi WDR teams,
I already checked the document of getSelectedCell(), it only shows the single value of cell which first clicked.
But what I want to implement is show the sum of the multi-selected cell value as attach shows, can give me a hint?
And the other question is how to color the particular columns and rows?
Thank you for your question.
The described feature is not implemented in WebDataRocks current version. We recommend checking out Flexmonster Pivot which is the premium product developed by the same team.
Flexmonster provides functionality you want by default, please, find out an example: https://www.flexmonster.com/demos/pivot-table-js/.
Particular rows and columns are simply colored using
customizeCell object. More about it by the link: https://www.webdatarocks.com/doc/customizecell/.
Also, check out an example we made for you: https://codepen.io/webdatarocks/pen/VwwGbwz.
Hi WDR Team,
And the colored cell feature I learned from google chart demo. https://codepen.io/webdatarocks/pen/GBQrEo
but how can I just color some cells only? (as the yellow highlight in attached pic shows)
I just know how to color the whole row or column.
Thank you for your feedback.
Cell customization dependent on hierarchy and level name can be implemented using the approach demonstrated in the example.
Also, you will find information about each cell in the console so you could provide more detailed customization based on its properties.
We hope it helps.
Hi WDR Teams,
How can I hide the subtotal value only?
According to the example you gave if I selected “Do not show subtotals” in option, the colored cells are discontinuous. How can I solve it?
The current WebDataRocks version does not implement a described feature.
As for Flexmonster, such columns are hidden by default in case subtotals are disabled.