Sorting issue

[boorgura]

I've come across a situation where i need to sort the Pivot table, for a particular set of rows and leave others as is.

I replicated the same into a sample data set.

in the above Pivot, let say I have to just sort the level 4 where as B111, B112, B13. but leave the rest as is. (Especially A412, A411)

I mentioned that because, sort ascending would get the entire column to sort.

Any help would be highly appreciated.

Hint: if you cant see the image. Please copy the small symbol into WORD. It gets pasted as the Pivot - image.

Thanks in advance.

[boorgura · Accepted solution]

Actually, i achieved this by changing the load order in the QVD itself and then sorting by load order.