Let’s say we have two row groups, whenever we apply a top N filter it’s applied on the first group, although we are doing it for the second group of lines.
Is it possible to have it applied to the second group?
Thanks in advance for your help.
When using top N filter over some field, it is operated only over that field without any reference to the parent row. The “London” and “Porto” members got into the result since they have top 2 values among all “Group 2nd” field members.
It seems that your case requires calculating the top N filter for each parent member, respectively. Currently, such an approach is not supported.
Please contact us if additional questions arise.