We have updated WebDataRocks EULA, effective as of April 18, 2024. Learn more about what's changed.

How to know if a cell is under a parent measure and so change the cell background color?

Resolved

How to know if a cell is under a parent measure and so change the cell background color?
Or How to change background color of all cells under a parent measure?
Thanks.

1 answer

WebDataRocks Team WebDataRocks May 9, 2019

Hi Biagio!

To change the background color of the cells that correspond to a particular hierarchy, you can make use of the customizeCell function.

Here is a demo which shows how to change the background colors of all the cells from the rows that belong to a particular hierarchy (“Business Type” in our case). 
You can do the same thing for the columns.

For more details on the cell’s structure and customizing the cells, please refer to the documentation:

Regards,
WebDataRocks Team