help with filter

[beck_bakytbek]

Hi Folks,

i have the following situation:

my table does look like:

id	name	value	text
1	test1	10	aa
2	test2	20	aaa
3	test3	30	aaaa
4	test1	40	b
5	test2	50	bb
6	test3	60	bbb
7	test1	70	c
8	test2	80	cc
9	test3	90	ccc
10	test1	100	cccc

i tried to implement this expression : Only({<name = {"test1"}>}text), but it does not work

my expected output is field: text: aa, b,c,cccc

i know i can solve this issue in script by clausel where name = 'test1', but i want to know, whether is possible within a chart: pivot, straightable.

Thanks a lot for any and all help

Beck

[beck_bakytbek]

Thanks a lot Kushal,

i misplaced a charakter

, thanks a lot for your help

[beck_bakytbek]

Thanks a lot Martinez for your help

[beck_bakytbek]

Thanks a lot Surenda for your help