I am working on pulling sum of values from a particular table column in Celonis using PQL. I try to the sum of distinct values of the table column. However, when I do SUM(Table.Amount) it is giving me sum of all the values in the column and not the unique ones.
I want to get the 30000000 + 7500000 = 37500000.
How to sum the unique colunm values?