Forum Discussion
Error "A circular Dependency was detected"
Hello,
I have the error "A circular Dependency was detected" while sorting the group by a calculated column.
The columns A(groups) and B(groups) is crated by grouping the other columns.
Columns SortA and SortB are calculated columns :
| A (groups) | Sort A | B (groups) | Sort B |
| >8-16 | 3 | 0-4 | 0 |
| >8-16 | 3 | >8-12 | 2 |
| >8-16 | 3 | >4-8 | 1 |
| >64-96 | 8 | 0-4 | 0 |
| >24-32 | 5 | 0-4 | 0 |
| >48-64 | 7 | 0-4 | 0 |
| >4-8 | 2 | 0-4 | 0 |
| >16-24 | 4 | 0-4 | 0 |
| >2-4 | 1 | 0-4 | 0 |
| >24-32 | 5 | >4-8 | 1 |
| >48-64 | 7 | >4-8 | 1 |
| 0-2 | 0 | 0-4 | 0 |
| >48-64 | 7 | >12-16 | 3 |
| >96-128 | 9 | 0-4 | 0 |
| >24-32 | 5 | >8-12 | 2 |
| >16-24 | 4 | >4-8 | 1 |
| >32-48 | 6 | >12-16 | 3 |
| >24-32 | 5 | >12-16 | 3 |
| >32-48 | 6 | 0-4 | 0 |
| >32-48 | 6 | >8-12 | 2 |
| >32-48 | 6 | >4-8 | 1 |
| >96-128 | 9 | >12-16 | 3 |
| >48-64 | 7 | >20-24 | 5 |
| >8-16 | 3 | >12-16 | 3 |
| >2-4 | 1 | >4-8 | 1 |
| >4-8 | 2 | >4-8 | 1 |
| >192-256 | 11 | >16-20 | 4 |
| >192-256 | 11 | >20-24 | 5 |
| >256 | 12 | >32-40 | 7 |
| >24-32 | 5 | >20-24 | 5 |
| >96-128 | 9 | >8-12 | 2 |
| >96-128 | 9 | >4-8 | 1 |
| >48-64 | 7 | >24-32 | 6 |
| >16-24 | 4 | >12-16 | 3 |
| >2-4 | 1 | >12-16 | 3 |
| >256 | 12 | >20-24 | 5 |
| >256 | 12 | 0-4 | 0 |
| >128-192 | 10 | >16-20 | 4 |
| >128-192 | 10 | 0-4 | 0 |
| >48-64 | 7 | >8-12 | 2 |
| >96-128 | 9 | >20-24 | 5 |
| >4-8 | 2 | >8-12 | 2 |
| >8-16 | 3 | >20-24 | 5 |
| >4-8 | 2 | >12-16 | 3 |
| >48-64 | 7 | >16-20 | 4 |
| >24-32 | 5 | >16-20 | 4 |
| >96-128 | 9 | >24-32 | 6 |
| >16-24 | 4 | >8-12 | 2 |
| >64-96 | 8 | >8-12 | 2 |
| >32-48 | 6 | >20-24 | 5 |
| >64-96 | 8 | >4-8 | 1 |
| >64-96 | 8 | >20-24 | 5 |
| >64-96 | 8 | >12-16 | 3 |
| >96-128 | 9 | >32-40 | 7 |
| >16-24 | 4 | >16-20 | 4 |
| >192-256 | 11 | >12-16 | 3 |
| >256 | 12 | >12-16 | 3 |
| >192-256 | 11 | >24-32 | 6 |
| >96-128 | 9 | >16-20 | 4 |
| >64-96 | 8 | >32-40 | 7 |
| >128-192 | 10 | >20-24 | 5 |
| >32-48 | 6 | >24-32 | 6 |
| >32-48 | 6 | >16-20 | 4 |
| 0-2 | 0 | >8-12 | 2 |
| >128-192 | 10 | >4-8 | 1 |
| >192-256 | 11 | >8-12 | 2 |
| >64-96 | 8 | >16-20 | 4 |
| >4-8 | 2 | >32-40 | 7 |
| >128-192 | 10 | >12-16 | 3 |
| >2-4 | 1 | >8-12 | 2 |
| >8-16 | 3 | >40 | 8 |
| >256 | 12 | >40 | 8 |
| >64-96 | 8 | >40 | 8 |
| >256 | 12 | >8-12 | 2 |
| >8-16 | 3 | >24-32 | 6 |
| >192-256 | 11 | >4-8 | 1 |
| >24-32 | 5 | >24-32 | 6 |
| 0-2 | 0 | >4-8 | 1 |
| >2-4 | 1 | >20-24 | 5 |
| >64-96 | 8 | >24-32 | 6 |
| >256 | 12 | >4-8 | 1 |
Could you please advise?
Thank you in advance.
Tg
Anonymous , This how you should do to avoid this
Col1 = [Col]
Col Sort = Switch(True() , <Conditions on col1> )
Now mark Col Sort as the Sort column of Col1 and use that in visual
How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c
2 Replies
Anonymous , This how you should do to avoid this
Col1 = [Col]
Col Sort = Switch(True() , <Conditions on col1> )
Now mark Col Sort as the Sort column of Col1 and use that in visual
How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c