Repeating group: Group by condition = "Column A + Column B" is unique

Need help
1

Hi,

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

2

This topic was automatically closed after 70 days. New replies are no longer allowed.