Forum Academy Marketplace Showcase Pricing Features

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

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

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