Filter formula - return only certain rows from table

[uajeremy]

Basically, I have a table with about 30-40 columns. I'd like to create a filter with criteria but only return a few rows of the full source table.

here is an example

PRODUCT	EAST	WEST	SOUTH	NORTH	TOTAL
a	67​	61​	76​	21​	225​
b	23​	10​	43​	88​	164​
c	86​	96​	99​	34​	315​
d	56​	74​	23​	67​	220​
e	35​	90​	8​	49​	182​
f	93​	2​	5​	76​	176​
g	74​	6​	91​	98​	269​
h	10​	72​	4​	31​	117​
i	36​	76​	45​	70​	227​

Current formula returns the entire table
=FILTER(Table1,Table1[TOTAL]>200)

Can the Table1 argument specify to only return specific columns?

This didn't work but hopefully explains my question.
=FILTER(Table1[PRODUCT]&Table1[TOTAL],Table1[TOTAL]>200)

 

[DRSteele]

The formula in A13 here shows what happens when function FILTER is used on the whole Table. But you only want two specific fields to be reported and some records to be filtered based on a condition.

There are three ways that I have discovered. The first is to use function FILTER twice in adjacent columns (see A17 and B17). The second uses function CHOOSE to do the work (see A21), which is based on this MrExcel vid. The tird is a FILTER of a FILTER (see A25)

Notice that I have different numbers because the numbers you presented paste as text and I just couldn't figure out how to covert them - I even tried PowerQuery, but to no avail!

Book1
	A	B	C	D	E	F
1	PRODUCT	EAST	WEST	SOUTH	NORTH	TOTAL
2	a	242	77	217	32	16
3	b	279	201	216	85	51
4	c	206	108	166	144	296
5	d	190	236	285	3	3
6	e	237	288	173	162	284
7	f	196	139	91	175	46
8	g	242	43	256	143	200
9	h	239	234	11	268	130
10	i	58	167	49	88	253
11
12
13	c	206	108	166	144	296
14	e	237	288	173	162	284
15	i	58	167	49	88	253
16
17	c	296
18	e	284
19	i	253
20
21	c	296
22	e	284
23	i	253
24
25	c	296
26	e	284
27	i	253
Sheet65

Cell Formulas
Range	Formula
A13	A13	=FILTER(Table8,Table8[TOTAL]>200)
A17	A17	=FILTER(Table8[PRODUCT],Table8[TOTAL]>200)
B17	B17	=FILTER(Table8[TOTAL],Table8[TOTAL]>200)
A21	A21	=CHOOSE({1,2},FILTER(Table8[PRODUCT],Table8[TOTAL]>200),FILTER(Table8[TOTAL],Table8[TOTAL]>200))
A25	A25	=FILTER(FILTER(Table8,(Table8[#Headers]=Table8[[#Headers],[PRODUCT]])+(Table8[#Headers]=Table8[[#Headers],[TOTAL]])),Table8[TOTAL]>200)