Sum by Unique Value Not

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.


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

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!