I'm developing a report which has three groups. My report should do a group selection based on the condition on the summary count on the third group. Any suggestions on how to achieve this is highly appreciated.
My records will look something like this
Grp1 A
    Grp2 B
          Grp3 c  - 10(distinct count)
          Grp3 d  - 18(distinct count)
          Grp3 e  - 20(distinct count)
Grp1 X
    Grp2 Y
          Grp3 k  - 22(distinct count)
          Grp3 l  - 18(distinct count)
          Grp3 m  - 28(distinct count)
My report should display only those groups were the distinct count in any of the members in group3 has a value greater than or equal to 25..In this case my report will display only Group X, because the distinct count of group m is greater than 25.
My report should look like this.
Grp1 X
    Grp2 Y
           Grp3 k  - 22(distinct count)
           Grp3 l  - 18(distinct count)
           Grp3 m  - 28(distinct count)