Hacker News new | ask | show | jobs
by proamdev123 975 days ago
That’s what Power Pivot is for. Once you create the additional table and relationships as I described, you should be able to create a pivot table using data from multiple tables. No SUMIFs required. Unless I’m misunderstanding something.