How to count groups within a group?

[albaraash]

Hi,

I have this report (attached). Next to "NO of days", I want to count number of 'gray' groups within the 'blue' groups.
I tried all counts: Count, CountDistinct, cCount, colCount, with no success.

Then, I need to use a condition (CountIf) within it.

Question.PNG (56.53 KiB) Viewed 1379 times

Question2.PNG (101.62 KiB) Viewed 1379 times

[Alex K.]

Hello,

Please send us your report with test data for analysis.

Thank you.