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.

1 Like


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

Screenshot 2022-07-06 at 22.55.05


Thank you Koushik. That worked!!