- last edited on
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.
Best regards Fredrik
05-01-2019 11:00 PM
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.
05-02-2019 04:24 AM
by TALemieux on June 22, 2020
by Wyn Hopkins on May 05, 2017
by Wyn Hopkins on February 15, 2017