Pivot Table Outline View - Setting Row Indent

Hello,

Attached are two screenshots to help explain further, please see below

Basically, I have a Pivot Table I update each Friday with new data then re-run the pivot table. The columns always move over 1 cell when ran and I have to go cell by cell to decrease the indent for everything to be aligned. I have gone through different settings options and still always have to go cell by cell; Is there a way for excel to remember the order I want?

The "Start" attachment is how it is produced after refreshing the pivot table and the "Goal" attachment is how I manually align everything. It is not a huge issue but there are times when there are 2000 rows of data and spamming decrease indent is not ideal. Any recommendations will be greatly appreciated

maybe it will help

optionspt.png

I did this and when I pasted in the new data and refreshed, it was reset

did you save it before add refresh?

Like 99.9% sure I did - Let me make sure