Hi All,
I have a 2 SP lists and am trying to display data from 1 SP list in another List Form in Nintex Form using list view control.
Inorder to display the items, from the below list, Cal is the field that will show the count of Val field from the below list items
ID EN DE FR Val cal
1 EN1 DE1 FR1 1 2
1 EN1 DE1 FR1 1 2
1 EN2 DE2 FR2 2 3
1 EN2 DE2 FR2 2 3
1 EN2 DE2 FR2 2 3
1 EN3 DE3 FR3 3 1
2 EN1 DE1 FR1 1 3
2 EN1 DE1 FR1 1 3
2 EN1 DE1 FR1 1 3
2 EN2 DE2 FR2 2 2
2 EN2 DE2 FR2 2 2
2 EN3 DE3 FR3 3 1
Now in the list view, for ID 1 -
i should show distinct values based on Val and sort by Cal.
Means result should be as below.
ID EN DE FR Val cal
1 EN1 DE1 FR1 1 2
1 EN2 DE2 FR2 2 3
1 EN3 DE3 FR3 3 1
Can you please help how to achieve above functionality?
Thanks in advance,
Usha