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

    Pivot table calculations

      Hello,

       

      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?

       

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

       

      regards, Meike