title: Total of LOOKUP function in SSRS
body: <p>For each group in SSRS (Countries, cities...) I calculate sales divided by exchange rates:</p>
  
  <pre><code>Sum(Fields!Net_Sales_Amount.Value)/LOOKUP(Fields!Country.Value, Fields!Country.Value, Fields!RATE.Value, "Currency")
  </code></pre>
  
  <p>How I can create Total of this sum (sum for last group - countries)?</p>
  
  <p>Each solution that I found show how to do it only for alone LOOKUP function. I need to divide field by it.</p>
  
  <p>Here is layout of my report:</p>
  
  <p><a href="https://i.stack.imgur.com/FDJd4.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/FDJd4.png" alt="enter image description here"></a></p>
  
  <p>and structure:</p>
  
  <p><a href="https://i.stack.imgur.com/Sibge.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Sibge.png" alt="enter image description here"></a></p>
  
  <p>To calculate sales for country I just need to sum sales and divide it by LOOKUP function, but I couldn't do it for Total. I need to some below values.</p>