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
