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

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
 
Joined
Sep 6, 2016
Messages
2
Reaction score
0
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 :(
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top