pivot table without sorting

hy. ia have a pivot table in wich i want to keep de data order for PROIECT like in sheet1. in pivot sheet in column H, I put the values ​​as I would like to be displayed in the pivot tables.

You can manually sort the pivot table, just drag the rows and place them in the correct order.

Originally Posted by kersplash

You can manually sort the pivot table, just drag the rows and place them in the correct order.

And for 1000 rows situation? Isnt a good solution

You may have to modify your data or somehow apply a custom sort.

Watch this video;

https://www.google.com/search?q=cust...TF-8#kpvalbx=1