Get values from multiple selected cells and color specific column

Answered

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?

Attachments:
multi selected.JPG

5 answers

WebDataRocks Team WebDataRocks November 12, 2019

Hello, Jacinth,
 
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.
 
Kind Regards,
WebDataRocks Team

Jacinth November 20, 2019

Hi WDR Team,
thanks for the reply, I think I will only implement this feature by javascript due to the strict budget constraint. (I know flexmonster is so powerful..) 
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.

Attachments:
color.JPG

WebDataRocks Team WebDataRocks November 22, 2019

Hello, Jacinth,
 
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.
 
Kind Regards,
WebDataRocks Team

Jacinth November 26, 2019

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?

Attachments:
color.JPG

WebDataRocks Team WebDataRocks November 28, 2019

Hello, Jacinth,
 
The current WebDataRocks version does not implement a described feature.
 
As for Flexmonster, such columns are hidden by default in case subtotals are disabled.
 
Regards,
WebDataRocks Team