如何使用django orm获得简单的数据透视表？

# models.py
from django.db import models

class Sales(models.Model):
    product = models.CharField(max_length=100)
    category = models.CharField(max_length=100)
    quantity = models.IntegerField()
    price = models.DecimalField(max_digits=10, decimal_places=2)

# views.py
from django.db.models import Sum
from django.shortcuts import render
from .models import Sales

def pivot_table(request):
    data = Sales.objects.values('category').annotate(total_quantity=Sum('quantity'), total_price=Sum('price'))
    return render(request, 'pivot_table.html', {'data': data})

# pivot_table.html
<table>
  <tr>
    <th>Category</th>
    <th>Total Quantity</th>
    <th>Total Price</th>
  </tr>
  {% for row in data %}
  <tr>
    <td>{{ row.category }}</td>
    <td>{{ row.total_quantity }}</td>
    <td>{{ row.total_price }}</td>
  </tr>
  {% endfor %}
</table>