How to SUM unique values in Data Studio?

Question

Is there a way to flag all unique values within a numeric field and then sum them? Or an alternative to sum(distinct col) ?

I tried to create a sum of an aggregate field

SUM ( MAX(col) )

But data studio does not allow double aggregation, is there any other hacky ways you might know of?

question from:https://stackoverflow.com/questions/65943809/how-to-sum-unique-values-in-data-studio

Answer 1

Waitting for answers