Combine Tables With Different Dimensions

[rwb139]

Hello community,

I have a (potentially) unusual request. I have two tables, one with a dimension "Account Type" that includes values "Income", "Expense", "Other Income", and "Other Expense" and another one that I have created using a value list that combines these in different ways to create an NOI (Income - Expense), Total Income (Income + Other Income), Total Expense (Expense + Other Expense) and Net Income (Total Income - Total Expense). My question is how can I combine these tables to where the data shows up on my pivot table and my boss can more easily see the Total Income, Total Expense, and NOI. Please let me know if I can elaborate more, but he's really needing it to be in this format. 

[rwb139]

After playing with this for a long time, I was able to solve it by utilizing the ValueList() and then creating an excel pivot table and filtering out the 0 values.