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)



Thinking on..., are there any other easy solutions :)

5 comments:

  1. It works but how about when a new region gets added.

    ReplyDelete
  2. Sai,

    I knew that problem, I am working on it in a different way if i got solution i will let you know.

    ReplyDelete
  3. combine with another request by selecting 'All Regions' and price per unit, then apply the calculation that is required on price per unit.

    ReplyDelete
  4. Instead of selecting individual values of the Region for the calculated item just mention * in the formula box. This will include all the values for the Region (Current and Future)

    ReplyDelete
  5. Thanks vijay . it helps =

    ReplyDelete

Please give me your feed back