0 Replies Latest reply on Aug 30, 2017 4:00 PM by Koen Pelzer

    Orders per capita

    Koen Pelzer

      Hi guys,

       

      If I calculate orders per capita for the following table, Tableau divides the sum of orders by the average of inhabitants. This is the correct outcome, tough, howcome doesn't Tableau take the sum for both columns?

       

      Thanks ^^

       

      CityOrdersInhabitants
      Amsterdam500600000
      Amsterdam600600000
      Amsterdam800600000
      Rotterdam400450000
      Rotterdam300450000
      Rotterdam200450000

       

      Koen