How to change the background color in pivot table if total value is 0
I have pivot table it contains data for Jan to Dec month. Finally it shows the total values. Here I need to change the background color if total value contains 0 that entire row will appear into blue color.
Here I have total column if it contains value 0 the entire row background color should be in blue. Colud you please help me on this issue.
Hi, it would be easier then to reference the column in the expression itself, that way you can change the calculation in Total if needed and the if-statement will be referencing the updated expression.:
Yes, in expression itself we can able to achieve that but if place this expression in background the blue color appears into all 0 values but for us if total value 0 then that entire row must be converted into blue.