How to divide two aggregated field value pivot table - quicksight during expand or collapse?

[na009]

Hello,
Here is another illustrated reference,

Does conditional formatting apply when column collapse?

Hello QS expert! Is it possible to show Y/G/R light formatted when collapse a row? For example, if all rows are expended, the conditional formatting will apply properly. However, when collapse any row, the conditional formatted will be gone. (pls see screenshot). Thanks a ton!! [image (2)] [image (1)]

How to calculate YTD % Goal - AMER - 94.82%