Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Actually, i achieved this by changing the load order in the QVD itself and then sorting by load order.
Actually, i achieved this by changing the load order in the QVD itself and then sorting by load order.