title: Google Data Studio : how to obtain a SUM related to a COUNT_DISTINCT?
body: <p>I have a dataset including 3 columns :</p>
  <ul>
  <li>ID transac (The unique ID of the transaction - Dimension)</li>
  <li>Source (The source of the transaction - Dimension)</li>
  <li>Amount € (The amount of the transaction - Stat)</li>
  </ul>
  <p><a href="https://i.stack.imgur.com/fp6v3.png" rel="nofollow noreferrer">screenshot of my dataset</a></p>
  <ul>
  <li><p>To Count the number of transactions (for one or more sources), i use COUNT_DISTINCT function</p>
  </li>
  <li><p>I want to make the sum of the transactions amounts (for one or more sources). But i don't want to additionate the amounts of the transactions with the same ID !</p>
  </li>
  </ul>
  <p><strong>Is there a way to do this calcul with a DataStudio function ?</strong></p>
  <p>Thanks for your answers. :-)</p>
  <p>EDIT : I saw that we could do this type of calculation via SQL <a href="https://stackoverflow.com/questions/58960009/sum-distinct-by-key-or-symmetric-aggregates-function-in-bigquery">here</a> and I would like to do this in DataStudio (so that I don't have to pre-calculate the amounts per source.)</p>