Jan-09-2023, 05:45 PM
I figured out my question #1. Remove index=False in pivot.to_excel(writer, sheet_name='Pivot', index=False).
For #2, the order is in the order I specified when I created another Python scripts. Not sure why.
I will still need help on #3. The Grand Total is incorrect for calculated columns. I also need help on how to have subtotal.
Thanks.
For #2, the order is in the order I specified when I created another Python scripts. Not sure why.
I will still need help on #3. The Grand Total is incorrect for calculated columns. I also need help on how to have subtotal.
Thanks.