Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
1.How to change the color of the null value of the PivotTable?
2.How to change null value '-' to another name?
Thanks.
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.
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.