HI. we are working with a number of Power pivot files in our office. We extract the content from Microsoft NAV.
But I can't get the power pivot table to sort the way I want.
If I use sort option for each column that is shown when you click the little arrow in the top of each column nothing happens.
AND I cant rearrange the columns because in a secondary step, we use this Power pivot table to create an import file for Rapid start in NAV and if I rearrange the columns the import file will not work.
So the sorting is hierarchical from left to right, so Item No_ is the first sort level, then WITHIN that the description is sorted and so on as you move to the right.
There's not really a way around it that I'm aware of without a) changing the order of columns b) adding a Sort Number column to the far left column c) Using Power Query to create the table rather than Power Pivot