title: Dynamic Range in Google Sheets Pivot Table
body: <p>I want to build pivot table with dynamic range in "Google Sheets". Please help me with the same.</p>
  
  <p>In Microsoft Excel we can achieve this with Offset function in pivot table. I am looking for similar solution.</p>
  
  <p>I have tried using Named Range, Offset Function and also app script but none of them is working.</p>