I am trying to apply conditional formatting on pivot table’s columns based on a pre-defined (sales) target value. I have created a new calculated field to round Sales values up to two decimals. The condition is getting applied on single values, but not for Totals and Subtotals as shown on screenshots.
On the example below, I would like to round the Total sales value for the Food category from 99.778 to 99.78, so that the cell will get green colored. Do you have any suggestions, how to implement such a formatting?