9 Replies Latest reply: Dec 17, 2012 8:52 AM by pcarvalho RSS

    Pivot table calculations



      I want to change the color of cells in the pivot table below (example) if the value exceeds the value of the previous year.

      I tried the use of aggr, above, column etc, but I can not find the right formula.


      Can anybody help with this?


      bikeblue 12151316
      bikeorange 14171417
      bikered 13161316
      carblue 45505055
      carorange 30353235
      carred 50555055


      regards, Meike