How to count groups within a group?
Posted: Sun Apr 16, 2017 5:52 am
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.
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.