• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Sum of Sums in Power Pivot


New Member
After a number of years out I am returning to Power Pivot modelling. I have set up my data model which is behaving correctly so far for simple stuff. I am attempting to summarize 4 tables in to one. Each table contains "customer". One table has existing business deals with all customers, another table has mandated deals (not yet commenced). I want a column in the output pivot table to show Total business for each customer, which includes an aggregated sum for each customer in the first table (existing) + aggregated sum for the each same customer of mandated deals in the second table (mandated). So for each customer, Total Business = Sum(all existing deals) + sum(all mandated deals). Any help is appreciated. Thanks