🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all hot features!
Get Free Trial

Top N for row, not for row root parent

Ricardo Gaspar asked on December 20, 2019

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.

1 answer

Illia Yatsyshyn Illia Yatsyshyn Flexmonster December 20, 2019

Hello, Ricardo,
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.
Best regards,

Please login or Register to Submit Answer