Not sure whether you could do a join your data to itself or not, but just give a solution may suit your case.
below is the steps
1st, join your data to itself by key 1=1
2nd, create a calculation field as flag and then you can make it as yes/no, I just show the true/false
Hope this helps
Book2_v10.2.twbx 9.9 KB
Hi, thanks for the try but as I said I can't use LODs due to limitations with my data source. Thanks anyways