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.
I have created that Total column in show partial sums for Month dimension in pivot table under presentation tab. In which place if i place the expression it will work perfect?
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.
Yes.here what i actually did in pivot table, i have month as dimension after creating pivot table i dragged the month dimension to new dimensions now it consider as every month as dimension.
After dragging into new dimensions,
Month Jan Feb Mar like this thats why i can't able to fix this.