title: Sum of group items SSRS 2005
body: <p>Is there a way to sum the numeric values of a group?</p>
  
  <p>My report is structured in a couple of groups like so</p>
  
  <pre><code>Group1
      Group2
          Group3
              Data
  </code></pre>
  
  <p>The names of the groups would look look like </p>
  
  <pre><code>League
     IsHomeTeam
        Team
            Player
  </code></pre>
  
  <p>So an example of the report structure would be</p>
  
  <pre><code>NHL
      True
          NJ Devils
              Martin Brodeur    Stat1    Stat2
              Patrick Elias     Stat1    Stat2
              ....
  </code></pre>
  
  <p>What I'd like to do is get the Max of Stat1 for group3 (Team), then get the sum of that number for group1 (League).  </p>
  
  <p>This is similar to another question here but I'm asking for SSRS 2005.<br>
  <a href="https://stackoverflow.com/questions/13309211/summing-group-items-in-ssrs-2008-r2">Summing Group Items in SSRS 2008 R2</a></p>
  
  <p>When I tried using Sum(Max(Fields.Stat1.Value,"Team"),"League") I got an error saying "Aggregate functions cannot be nested inside other aggregate functions".  </p>
  
  <p>Does anyone have another way of doing this?</p>