title: How can I have multiple pivot tables in same sheet?
body: <p>I have a big sheet with quite a lot of info that keeps growing over time. Based on that, I have created several pivot tables that do some calculations and rankings.</p>
  
  <p>Every ranking keeps growing, so pivot tables may contain 10 rows now, but can grow up to 20 or 30 rows.</p>
  
  <p>I managed to <a href="https://stackoverflow.com/a/45061015/1983854">insert several pivot tables in the same sheet</a> and now it looks well, with every ranking after the next one. However, if I add multiple rows, the pivot tables grow and start overlapping, so after a while the ones below start disappearing in favour of the first ones.</p>
  
  <p>Is there a way to have multiple pivot tables in the same sheet with a fixed number of rows among them, preventing them from overlapping?</p>
  
  <p>If you want to 'play' with the data, I created a sample in <a href="https://docs.google.com/spreadsheets/d/1MVX3tp6GIqVX6hTyk6TsCxV7YngiMpi7E8oSxa7a9ck/edit?usp=sharing" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1MVX3tp6GIqVX6hTyk6TsCxV7YngiMpi7E8oSxa7a9ck/edit?usp=sharing</a>. It is just a ranking on races, where I want to track the best times on different legs. Then it has a second sheet 'rankings' in which I have different pivot tables, one for each leg.</p>