1 Reply Latest reply on Aug 18, 2016 6:14 AM by Luciano Vasconcelos

    Find sum and average value in group

    Aleks Roth

      Hello, I newbie in tableau.

       

      Tell me please.

       

      Example:

      country,City,population(millions)

      France,Paris,1.25

      France,Nice,2,3

      France,Strasbourg,2,1

      America,New York City,4,5

      America,chicago,3,4

      America,Detroit,2,0

      Germany,Berlin,2.5

      Germany,Cologn,1.3

      Germany,Hanover,0,9

       

       

      How find sum and average value population people by country?

      Example:

      country,population(millions)SUM,population(millions)AVG

      France,5,65

      America,9,9

      Germany,4,7