Grand Average in place of Grand Total in Pivot Table

75,180

Right-click the cell where you want to show the average, select Summarize Data By and then click Average.

enter image description here

Share:
75,180

Related videos on Youtube

G-Man Says 'Reinstate Monica'
Author by

G-Man Says 'Reinstate Monica'

Updated on November 27, 2022

Comments

  • G-Man Says 'Reinstate Monica'
    G-Man Says 'Reinstate Monica' 12 months

    In a pivot table I want to change the Grand Total field to Grand Average. For example.

    Row Labels   Day1   Day2   Day3   GrandTotal
    1             10     20     30        60
    2             15     25     35        75
    3             20     30     40        90
    

    And I want it to be like:

    Row Labels   Day1   Day2   Day3   GrandTotal
    1             10     20     30        20
    2             15     25     35        25
    3             20     30     40        30
    
  • Admin
    Admin over 6 years
    The 'Average' Selection is greyed out for me. Any idea why?