title: how to merge data from several tables in a pivot table
body: <p>I want to create an overview monthly report for all the data in the worksheet. So for June, I'll see the sum of expenses, and sum of revenue, each existing in different tables.</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Expense</th>
  <th>Date</th>
  <th>Price</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>expense 1</td>
  <td>22/06/2022</td>
  <td>100</td>
  </tr>
  <tr>
  <td>expense 2</td>
  <td>25/06/2022</td>
  <td>120</td>
  </tr>
  <tr>
  <td>expense 3</td>
  <td>07/07/2022</td>
  <td>60</td>
  </tr>
  </tbody>
  </table>
  </div><div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Revenue</th>
  <th>Date</th>
  <th>Amount</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>Salary</td>
  <td>11/06/2022</td>
  <td>150</td>
  </tr>
  <tr>
  <td>Interest</td>
  <td>01/07/2022</td>
  <td>20</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Desired result</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Month</th>
  <th>Expenses</th>
  <th>Revenue</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>06-2022</td>
  <td>220</td>
  <td>150</td>
  </tr>
  <tr>
  <td>07-2022</td>
  <td>60</td>
  <td>20</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>(I have a helper column month which converts date to a string month in the <code>m-yyyy</code> format)</p>
  <p>I added all the tables to a data model, and created a pivot table from the data model. My problem, is that even though each table has the hidden &quot;month&quot; field, e.g. <code>06-2022</code>, for a &quot;row&quot; I have to select a month field from a specific table, and then other table does not break down for that month. And if I select both <code>month</code> fields for the pivottable row, I just get nested data.</p>