3 Replies Latest reply on Sep 4, 2017 8:56 PM by Daniel Corcoran

    Sum distinct values within two categories

    Daniel Corcoran

      Hey guys

       

      Looking to sum distinct values within two categories. I want to make a calculated field that shows the sum of 'Lga.Population' for each year within each region. Note there is only 1 region in this dummy data, so the results should be 6000 for region a > 2014 and 8000 for region a > 2015. Any help would be much appreciated thanks.