1.How to change the color of the null value of the PivotTable?2.How to change null value '-' to another name?

[Anonymous]

1.How to change the color of the null value of the PivotTable?

2.How to change null value '-' to another name?

Thanks.

[niclaz79 · Accepted solution]

1. Check expression text color. Condition: if(isnull(), RGB(100,100,100))

2. In Presentation tab, you can change the null and missing value to whatever you like.