ust now saw a post in OTN on Conditional Formatting in Grand Total - Pivot Table View, here is a possible work around for this.
Sample Exp
Region price per unit
south 89
north 86
west 92
east 99
Grand total 91.5
Conditional format is if 90% above is green other wise red this works well on individual cells but not in default grand total option.
Possible solution is, create a report with required columns and apply required conditional formats on columns. Create pivot view, locate column choose more options, on click menu choose “new calculated item …” select function as AVG and select all available columns, give a name Grand Total or what ever may be say ok.
Now you can able to see conditional format on custom row "Grand Total Row".
Here are steps to do that(Paint Example)
 |
| From O.B.I.E.E |
Thinking on..., are there any other easy solutions :)
Posts
