1 Reply Latest reply on Jul 17, 2018 10:23 AM by Deepak Rai

    Getting Totals for value in specific column

    Yusheng Xia

      Lets say I have Cities, and I set them based on Regions. Now due to errors in database, many cities are listed under multiple regions. Each city has its unique revenue. So it would look something like this.

       

      CityRegion
      Revenue
      New YorkNew York6000
      Manhattan5000
      HoustonDallas1000
      Houston6000

       

      I used      

        If ([Total Bundles]) == ({FIXED [City]:Max([Revenue])}) THEN ([Region]) ELSE NULL End

      and set it as a filter in order to narrow down each city to only include one region (the one that has the largest revenue).

       

      However, how do I get the total per city to stay the same? I want it to look something like this

       

      City
      Region
      Revenue
      New YorkNew York

      11000

      HoustonHouston7000

       

      Any ideas?