Get the values based on filtered data in other fields using set analysis

[Anonymous]

If you will look at the above chart, Jodzis,Jeffrey M is  in the filter conditions, yet it has been assigned Rank 2.

So when I use

=(Concat
({<[Field B] = {"=rank(Count([Field B]))=1"},
Template={"=rank(Count(Template)))=1"},
Name={"=rank(Count(Name)1,1)<=3"} 
>} 

Aggr(Only(Name) & ' ('&Count(Name)&')', [Field B], [Name]))) , I will only get Eagan,Caroline Burlingame(11). But I should also get all Names with count 3 and 2 like MaDonnell,,,Turner. 

[sunny_talwar]

Would you be able to share the application to look at the issue? I am not 100% sure what you are looking to get here

[Anonymous]

I am so sorry cant do that due to policy issues. I will explain it further.

I have say 10 fields and among those 10 are [Field B] and Template.

So  first I need to filter which data based on max no of count in [Field B]. In other words I have to filter the dataset where [Field B]=max(count(Field B). Further I have to apply 2nd level filter on the above dataset, to filter the data based on max no of count in template .In other words 2nd level filter will beTemplate]=max(count(Template).

Once I have the filtered dataset, I have to get top 3 names. My question is how will I RETREIVE the top 3 names in the filtered dataset

[Anonymous]

Can you please help on this. Need to get it working...