Pivot Table conditional Color when collapsed


I have applied a conditional formatting based on dimension and measure on a pivot table, which is working as expected, where the color is being applied per dimension value and the measure value ( logic in the calculated field in a if-else) when the pivot table is expanded ( un-collapsed). When collapsed, the color rule does not take into effect. Any thoughts? Please note the correct value is printing but seems like Quicksight does not apply the color when collapsed.


You can enable conditional formatting for subtotals and totals ( click on “” ) :

Screenshot 2022-07-06 at 22.55.05


Thank you Koushik. That worked!!