Create a new pivot table from multiple tables

Create a new pivot table from multiple tables

I really need help. I am stuck on this for a week  and now I have a deadline.
I have two tables say Table A and Table B. I created aggregate formula for both the tables. Now, i want to present them in a new pivot table. When I drag aggregates for both the tables. The data for Table B (or any 2nd data column) is repeated for all the months.