title: Multiple Pivot table in singe worksheet with Python
body: <p>I want to generate multiple Pivot tables and move them to single excel worksheet.</p>
  
  <p>I am able to generate Pivot table but once i am coping to single working sheet only last one is visible all rest are lost.
  I am using below code:</p>
  
  <pre><code>with pd.ExcelWriter("columncondtition.xlsx") as writer:
      pivot.to_excel(writer, sheet_name="Pivot Report")
      pivot1.to_excel(writer, sheet_name="Pivot Report")
  </code></pre>
  
  <p>How this can be done? </p>