title: How to do a period over period comparison in Amazon QuickSight?
body: <p>I want to compare data from the current period (e.g current month) with the previous period (e.g. last month).</p>
  <p>Let's say I have the following dataset:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>date</th>
  <th>orders</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>2020-01-01</td>
  <td>1</td>
  </tr>
  <tr>
  <td>2020-01-02</td>
  <td>2</td>
  </tr>
  <tr>
  <td>2020-01-03</td>
  <td>5</td>
  </tr>
  <tr>
  <td>2020-02-01</td>
  <td>4</td>
  </tr>
  <tr>
  <td>2020-02-02</td>
  <td>2</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>And I want to get:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Jan 2020 Orders</th>
  <th>Feb 2020 Orders</th>
  <th>Delta Orders</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>8</td>
  <td>6</td>
  <td>-25%</td>
  </tr>
  </tbody>
  </table>
  </div><hr />
  <p>Period can be selected by user.</p>