Forum Discussion
Sorting a power pivot table
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...
This is what the file looks like.
I'd like to sort it by any of the columns that I have marked with yellow and a red line.
If you look at the small arrow in the 2nd column called description you'll see that it's sorted by this column, but if you check the products below you can see they're not in alphabetical order.
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
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
OK, thank you, I'll have to look in to power query then :) Wyn Hopkins