Excel How to preserve column fields in a specific order in a pivot table?

Y

yonibarash

Joined
Sep 6, 2016
Messages
2
Reaction score
0
Hi guys,
So I've created a pivot table which i want to use as my default template file for any future data sources.
I sorted the fields in the desired column order which i wish to keep.
The problem is, that every time that i choose to hide \ reveal a certain field (checking the "v" sign on the fields list on the right),
that field gets thrown back to the end of the table as the last column.
I wish to be able to play with different fields and hide them, as i don't always need to see all of them, but that they will always appear where they originally were.

I tried creating a custom list, but did not manage to make that happen unfortunately.
Please help!
Thank you
 
Hi, thank you very much!
I've went through your links, but unfortunately didn't succeed :\
The thing is, custom lists works well for data inside a certain column, but i wish to control the order of columns (fields) in the pivot table. I made a list by the columns' names and apply it (sort data), but it didn't do anything.
I wish i could have upload the Excel file here so someone could check it out :(
 
Back
Top