Sort, Unique, Filter and Large Functions

[Minx_Minxy]

Hello,

I have a large set of data, I am trying to filter it, but only have 25 values. I am trying to use the Large function, but it is only bringing me 1 value. Any thoughts?

=LARGE(SORT(UNIQUE(FILTER(CHOOSE({1,2},VimsDay[Document Id],VimsDay[Days to Due]),(VimsDay[Extraction Date]=Pivot_DailyVIMs!$G$3)*((VimsDay[Days to Due]<0)*(VimsDay[Days to Due]<=Pivot_DailyVIMs!$H$2)),"")),2,1),25)

 

[Fluff]

Replace Large with TAKE

 

[Minx_Minxy]

Replace Large with TAKE

Excellent, I turned all over the internet and TAKE function never appeared. Thank you so much

 

[Fluff]

You're welcome & thanks for the feedback.