How to assign background/text color to Total column in the Pivot table only after the expansion
Problem: I have a pivot table which has multiple columns. I want to assign background/text color to the Total value but only when the all the columns are expanded based on a condition, for ex : If(Count(Distinct(Field)) > 50,Red()) or something like this. But I don't want the condition to work on the default view. It should only be applicable when for a row all the columns are expanded.
Please let me know if there's any way i can implement this.