LET() and FILTER() help needed

[realtoast]

Experts, I'm a couple hours into a puzzle. I am creating a single cell dynamic spilled array with the LET() function. From the below table snippet, the result I want is a dynamic table that filters for Type = Medical. The formula I've come up with that almost works is:

=LET(
f,FILTER(Data, Data[Type]="Medical"),
y,Data[Year],
type,Data[Type],
c,Data[Carrier],
t,Data[TotalCost],
erperc,Data[ER%],
er,Data[ER Total],
tbl,CHOOSE({1,2,3,4,5,6},f,type,c,t,erperc,er),
tbl)

In the table, Data, the fields are:

Year

Type

Carrier

Plan

Tier

Enrollment

Rate

ER%

EE%

ER Rate

EE Rate

ER Total

EE Total

TotalCost

The result I want from the above LET() is

Year

Type (Medical only)

Carrier

TotalCost

ER%

ERTotal

In the table, there are the following "Type"s. I want to exclude all types except Medical:

Dental

Life ADD

LTD

Medical

STD

Vision

My table has a couple thousand records, so I hope the above examples make sense. The above formula results in the below result, which is not filtering for Medical only. Here are pics of the data table, Data, and the result of the above formula

 

[hagia_sofia]

Hello, what does this return:

=CHOOSECOLS(FILTER(Data,Data[Type]="Medical"),1,2,3,14,8,12)

 

[realtoast]

Hello, what does this return:

=CHOOSECOLS(FILTER(Data,Data[Type]="Medical"),1,2,3,14,8,12)

Eggsellent! This works famously. Thank you!