Conditional Formatting in Grand Total in Pivot Table View

Just 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 :)