Hi all,
I have a doubt. I have a SP List with three coulmns RecipientName , Function and Type.
Here, ReciepientName is Single line of Text, Function is Lookup and Type is Single line of Text.
Now what i want is, i get a values from sp list and display on gallery.
In that gallery i need to do a Avoid duplicate Recipient Value and want to show thier function and Countrows of Type column.
This is my SP List,
| RecipientName | Function | Type |
| Dhinesh | Sharepoint | Helpful resource |
| Dhinesh | Sharepoint | Innovative |
| Suresh | Java | Hard Worker |
| Suresh | Java | New Perspective |
| Dani | Mobile Banking | Helpful resource |
| Rajan | .net | Hard Worker |
Now i want to get a details from this list and need to display into a gallery.
i want a gallery like this,
| Recipient Name | Function | CountRows(Type) |
| Dhinesh | Sharepoint | 2 |
| Suresh | Java | 2 |
| Dani | Mobile Banking | 1 |
| Rajan | .net | 1 |
This is what i need a Result.
In my gallary i want to avoid a duplicate values and then their Function finally i need a count of how many types they have.
This is possible?
Thanks,
Dhinesh
