0 Replies Latest reply: Jun 22, 2010 8:36 PM by Patrick De Waegenaere RSS

    Find the Average, Max and Min in calculated column in Pivot Table

      Dear Guru's, I have a Pivot table like this: Date Total A Total B Total C 01-02-2010 100 50 45 02-02-2010 34 44 67 03-02-2010 44 5 87 04-02-2010 2 33 74 05-02-2010 76 555 96 06-02-2010 65 31 26 07-02-2010 188 43 14 The total are the result of an expresion sum(if (Embarcaci´┐Żn='A',HeadCount,0)) Now I want for each column to identifie the Max and Min in the same table with a visual efect, and will also like to see the average of each column. Any sugestions, idea or tip to do that. If it cannot be done in the same table, I'm open to any sugestions. Thanks In advance for any help.