I have two pivot tables: [CREDIT TBL] and [EMP TBL]. (see screenshot below)
[CREDIT TBL] is the money I received from clients.
[EMP TBL] is the money I paid employers.
Both source tables ([tbl_clients] and [tbl_emp]) are structured completely differently so I don't see a way to combine them into one pivot table. (Since there is no relationship between them so no primary key to choose)
What I really only need is a third pivot table that would look the same as the ones in the screenshot below but the values should be [CREDIT TBL] - [EMP TBL].
This way, I would see the total profit (income - paying employers).
I can't figure out how to create a third pivot table, based on the two current ones.
Any help would be greatly appreciated.
EXCEL_BDRCSWptN2.png
Bookmarks