title: Combining values and annotate on a django query
body: <p>I have a query that looks like the following:</p>
  
  <pre><code>filter = Q(filter stuff)
  q = MyModel.objects.filter(filter).order_by().values('c1', 
                                                       'c2', 
                                                       'c3').annotate(Sum('c2'), Sum('c3'))
  </code></pre>
  
  <p>Now when I do this, the output essentially has all the unique triples of <code>c1</code>, <code>c2</code>, and <code>c3</code>.  Which I don't want.  I want it find all the unique values of <code>c1</code>, and add up the corresponding values of <code>c2</code> and <code>c3</code>.</p>
  
  <p>I was able to fix this by changing the query to the following</p>
  
  <pre><code>q = MyModel.objects.filter(filter).order_by().values('c1', 
                                                      ).annotate(Sum('c2'), Sum('c3'))
  </code></pre>
  
  <p>Which is great and gives me the desired output...but what I don't understand is why...</p>
  
  <p>Shouldn't <code>values</code> specify the columns that I want, not restrict the output to the unique pairings of those outputs?  Any help would be appreciated</p>