The question is about grouping for the dataset below:
Count of People
Site X Alias
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.