Forum Discussion
Formual Error
Trying to create and excel sheet that shows the top 3 tour members for each month of the year but the formula i'm using to show me that information is showing up as an error and i'm confused as to wh...
This reply was based upon a copy of the IlirU dataset and generates the result crosstab shown in yellow.
= LET(
TOP3λ, LAMBDA(s,t,IF(@s>=LARGE(t,3), @s, 0)),
crosstab, PIVOTBY(Attendance, DATEVALUE("1/"&Month), Point, TOP3λ,,0,,0),
nonblank, BYROW(DROP(crosstab, , 1), OR),
FILTER(crosstab, nonblank)
)The Lambda function TOP3λ returns a scalar '@s' if it is one of the top 3 values within the overall list of points 't' for the month, 0 otherwise. Blank rows are then filtered out.