Why Background Color/Links/Icons are missing when we use Expand/Collapse concept in matrix table

[ManoharGorantla]

Hi Team,

I have created a parent/child products hierarchy using matrix table with expand/collapse(+/-) icons. Also implemented background color and Icons based upon some condition for multiple columns. When we expand/collapse all products, we are able to see the background color and Icons but when expand particular parent product to see their child products data, It will show all the conditional formatting to that parent/child products data and do not show the  conditional formatting to other parent products.

For more clarity, I'm sharing the screenshot, where one parent product is expanded and it will show bar chart to their child products and the same bar chart will not show to other parent product except selected one.  If anyone have any idea, please share.

When we Expand all Parent Products, it will show Bar chart for total products in YOY columnWhen we Collapse all Parent Products, it will show Bar chart for total products in YOY columnWhen we expand particular Parent Product, it will show Bar chart for that and will not show to other parent productscolumn

[HarishKM]

@ManoharGorantla  You can use feild formatting option from there you can format the background color as well .

Kindly explore that option too.

[amitchandak · Accepted solution]

@ManoharGorantla , when using conditional formatting, there is an option to choose,

only for values, values, and total

use values and total