Is there a way to apply conditional formatting to pivot table aggregated metrics, even when the field hierarchy is collapsed? At the moment, the conditional formatting will only show when you have expanded your hierarchy to the lowest level. Thank you.
you can enable Subtotals/Totals (at default Value only enabled)on the condition you configured.
Is there a way to do this with the fill type gradient?