Using Collect function within Large function

Allison_S

Hello All, 

 

I am trying to nest a criteria within the LARGE function. I have 2 levels of children within my sheet and I have placed a hierarchy column so I can select just the children with a hierarchy ranking of "2" for the LARGE function. My formula below, but it is throwing errors. Any help would be appreciated! 

=LARGE(COLLECT((Hierarchy)@row, =2), [Total Sales Dollars]:[Total Sales Dollars]), (Rank@row))

Brian W

Try it this way:

=LARGE(COLLECT([Total Sales Dollars]:[Total Sales Dollars], Hierarchy:Hierarchy, 2), Rank@row)