Very often there is a need to calculate counts of various elements within groups or subgroup. This is very useful for calculating ratios. They key element of a ratio is to get the right denominator within desired filter context. Here I will describe the easy way to get any desired count of a group or…