Page 1 of 1

How to count groups within a group?

Posted: Sun Apr 16, 2017 5:52 am
by 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
Question.PNG (56.53 KiB) Viewed 1513 times
Question2.PNG
Question2.PNG (101.62 KiB) Viewed 1513 times

Re: How to count groups within a group?

Posted: Tue Apr 18, 2017 7:56 pm
by Alex K.
Hello,

Please send us your report with test data for analysis.

Thank you.