Sum by Unique Value Not

[Sarah]

I have a data set with several layers of grouping and detail but the value is unique to only one column. I need to not double count when making sums of the value to the levels of groupings.

The Topic, Classification, ID and Detail are all String values.

[thomask]

Hi,

maybe the solution in this thread will be of help for you. Its for averages, but could be used for sums.

How to calculate average value based on distinct values of another field

I have data that looks like this: Employee Employment Age 1 a 35 1 b 35 2 a 40 3 a 35 4 a 51 4 b 51 I want to calculate the average age of the individual employees. When I take the average value of the Age column then Employee 1 and 4’s ages are twice in data, giving me an average age of 41.2 . I need a calculation that first get the Age value for distinct Employee then averages those Age values. This should give me an average age of 40.3. Any idea about a formula that co…

[Peter]

Hi, @Sarah. Did @thomask’s solution work for you? I am marking his reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community Q&A Forum!