title: Excel 2013 PowerPivot Table - Many Fact Tables along with a Calculated Field
body: <p>I am pretty new on creating POWERPIVOT tables. I have searched for a bit of time now to resolve this problem but I have been unsuccessful so far. Here is my problem. As you can see below, I have created a POWERPIVOT table in Excel 2013 that is composed of two FACT tables, which are based on: 1) a sheet where the clients can insert initial budget entries; and, 2) another sheet where the clients can insert the post-initial budget entries. Also, a DIMENSION table has been added to the combination in order to add the following relationships:</p>
  
  <p><a href="https://i.stack.imgur.com/JaU2u.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/JaU2u.png" alt=""></a></p>
  
  <p>Based on these relationships, I have clicked on Insert a PivotTable to create the following POWERPIVOT table that will be used to display the Initial Budget and Adjustments entries for analysis purposes. However, this table does not give me the total of both columns. I have thought that a calculated field would make it happen but this is where I am stucked as nothing let me sum the two columns like I was used to do with regular pivot tables in Excel 2007. The calculation of the two columns would logically equal the Current Budget as shown attached.</p>
  
  <p>Thank you for your help on this.</p>
  
  <p><a href="https://i.stack.imgur.com/HXa0j.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/HXa0j.png" alt=""></a></p>