DataLink:Resort

2.63K viewsDataLink
0

When I use the datalink to build a OLAP analysis, where some columns are sorted descending, and then update the link, and now select ascending order, the column is not updated with the ‘new’ sorting order. Am I doing something wrong, or maybe mis-understand the usage of link updating? Thanks.

Carl

0

The way the existing functionality works is that the sort only applies to new data coming in. So if the update DataLink process really won’t do what you are looking for.

I would recommend that once you have the data in your matrix, to use the menu choices of <b><i>Tools > Sort Data</b></i> to sort based on cell data or <b><i>Edit > Reorder Items</b></i> to sort based on item name values.

-Mike