Sorting

[Anonymous]

Need help to sort a Matrix based on KPI column. I have a sort column in my table where I have assigned sorting order. I sorted KPI based on sort ID in table and it is working however in the view it is not.

In Matrix view it is sorting either by KPI or by $ amount.

Is there a way to sort Matrix view based on Sort ID without bringing this into the view?

Below is my table.

KPI	Prod Serv	Sort ID
CC	Product	3
UC Excl XYZ	Product	1
UC Inclu XUZ	Product	2
NW	Product	4
Profesionla Services	Services	5
Learning Services	Services	12
Support Services 11	Services	6
Support Services 22	Services	7
Support Services 33	Services	8
PCMS - AAA	Services	9
PCMS - BBB	Services	10
PCMS - CCC	Services	11

[jgeddes]

How exactly is the SORT ID column created?

[jgeddes]

You can use the Sort by column feature that is found in the table view under column tools.

highlight your KPI column and then sort by column SORT ID

[Anonymous]

@jgeddes I did that exactly but it is not working. Getting below error.

However the Column Sort is no way linked/referenced to KPI column. Both are coming from source file.

[jgeddes]

What result are you getting? By that I mean what is it sorting by currently?

[Anonymous]

it is sorting by KPI but in ascending order. Not consedering the SORT ID order

[jgeddes]

Can you share a screenshot of your table relationships? No data needed, just tables and column names. It would help to narrow down where the circular dependancy is coming from.

[Anonymous]

This table is linked to Geography and Date. there are around 7 more table which are linked to Geography and sate tables.