Apr 29 2019
01:05 AM
- last edited on
Jul 12 2019
11:24 AM
by
TechCommunityAP
Apr 29 2019
01:05 AM
- last edited on
Jul 12 2019
11:24 AM
by
TechCommunityAP
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
May 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.
May 02 2019 04:24 AM
May 02 2019 04:29 AM
OK, thank you, I'll have to look in to power query then :) @Wyn Hopkins