0 Replies Latest reply on Jun 20, 2013 2:55 AM by Sumana Kandaka

    Aliased fields in groups

    Sumana Kandaka

      Hi All,

      The question is about grouping for the dataset below:

      Site Group

      Site Name

      Count of People

      Sales

      Group A

      Site X

      1,000

      5000

      Group A

      Site X Alias

      1,000

      8000

      Group B

      Site Y

      500

      2000

      Group B

      Site Z

      800

      1000

      Total:

       

      2,300

      16,000

       

      Here, the Site X is aliased and is considered as 2 separate sites. So while in reality they are the same site, for other calculation purposes they are aliased and considered as two.

       

      When I take the SUM([Count of People]), I want the alias not to be counted, (value = 1000 + 500 + 800) as opposed to (value = 1000 + 1000 + 500 +800). Yet, if I select Site Name individually, I should be able to view the Count of People.

       

      Any ideas to proceed will be greatly appreciated.

      Thanks!