Get values from multiple selected cells and color specific column

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

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.

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

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?

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