Pivot Table from multiple table (to combine date column)

[Massad]

Hi guys, I'm really struggling in how to combine the dates from two different table in a pivot table.


The problem is when i combine the date, the excel just show me the normal data from de main table. It does only one way instead of both ways. It gets empty if I have an item on the secondary table only.

Sample.jpg

Someone has a solution for it?

Thank you for you attention.