Count instances of an item with certain values and display in infopath
Posted on 2011-09-30
I have infopath form and I have a data connection in it connecting to the sharepoint list I am working with.
Now I am trying to read certain column, let say column 'x' in sharepoint list and count the number of instances in that column that contains certain value, let's say 'y' and finally display that count information in infopath form.
How do I do that? I looked around and couldn't find any quick solutions.
Any helps will be highly appreciated.