the thing I'm working on is that pivot table should have data split by month. So I need to count different values from different sources and have them in one table, filtered by month, but every data source has own "date" field. Please find attached screenshot where my pivot table doesn't work properly, and below 2 simple tables with proper data in it. I think that "Columns" section needs to be rebuilt but I don't know how.
The thing is that I need data from these 2 simple tables in 1 pivot table. Is it possible, if yes - how?