I have the following data table:
And I want a repeating group to show the following:
I am having little luck with the Repeating group. Could you help out.
What I have managed to do so far is the following:
- Repeating group, type Text, source: do a search for Table PH_Level’s Location:unique
-And then a nested repeating group, type Text, source: do a search for Table PH_Level’s Date:unique <where Location = Current Cell’s text).
But I am unable to get the count of PH_Level entries inside the nested RG with two conditions (on date and location).
Could you help. Thanks