Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- result = list(transactions.values('customer').annotate(total=Sum('total'), gems=ArrayAgg('item', distinct=True)).order_by('-total')[:5])
- for item in result:
- sorted_gems = []
- for gem in item['gems']:
- for other in result:
- if other != item:
- if gem in other['gems']:
- sorted_gems.append(gem)
- break
- item['gems'] = sorted_gems
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement