Sort based on unused field in power pivot not working

[manekankit]

I am trying to sort pivot table fields based on sort order given in the table, however system seems to be ignoring sort order. Requesting community members to guide how to achieve required sort order in the pivot table.

Sheets in the file:
1. TB- Trial Balance having GL code and values
2. Parent - Having GL description, GL Note and GL sub-notes (i.e. parent and sub-parent of GL) and sort order
3. Pivot - having two pivot tables, first (left) which is auto-generated with source data sort order and second (right) where manual sorting/sequencing is done.

Required: pivot table should be auto-generated based on sequence defined in the sort column.

Images are attached.

 

[manekankit]

Attaching images. Were not uploaded with the original post.