Sort By Column

[NewbieJono]

Hello the sort by coloumn does not seem to be working for me. The error states there can't be more than one value in H position for the same value in work stream group.

Group	COO Workstream	Workstream	H Position
D	Calls Queued to Advisor	CC-Calls Queued to Advisor D	1
DM	Calls Queued to Advisor	CC-Calls Queued to Advisor DM	1
V	Calls Queued to Advisor	CC-Calls Queued to Advisor V	1
Contact Centre	Calls Queued to Advisor	CC-Calls Queued to Advisor Contact Centre	1
Actual YTD	Calls Queued to Advisor	CC-Calls Queued to Advisor Actual YTD	1
D	E-mails Answered by Advisor	CC-E-mails Answered by Advisor D	2
V	E-mails Answered by Advisor	CC-E-mails Answered by Advisor V	2
Contact Centre	E-mails Answered by Advisor	CC-E-mails Answered by Advisor Contact Centre	2
Actual YTD	E-mails Answered by Advisor	CC-E-mails Answered by Advisor Actual YTD	2
D	E-mail Call-Backs	CC-E-mail Call-Backs D	3
V	E-mail Call-Backs	CC-E-mail Call-Backs V	3
Contact Centre	E-mail Call-Backs	CC-E-mail Call-Backs Contact Centre	3
Actual YTD	E-mail Call-Backs	CC-E-mail Call-Backs Actual YTD	3

[selimovd · Accepted solution]

Hello @NewbieJono ,

yes, if you sort a column by another one the values have to be unique.

So if you sort column "Workstream" by "H Position" you don't have unique combinations.

But you should be able to sort column "COO Workstream" by "H Posision".

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi