How do you put a filter in a table

[Anonymous]

I have created a table that I want to pubulish. I only want to display  returnable item.  How do I go about doing it in which I can eliminate the 'Returnable column' from the grid and have the table  just display  values where Returnable = 'Y'.

Is there a way to preset the tables to have it automatically filter a set value such as returnable = 'Y'. ?

Thanks for your help

Customer Number	ORDERNUMBER	Debit Memo Number	Returnable	Credit Amount	Order Fee	Check credit Memo  Amount	Check/Credit Memo Number
102	102-2016-100	EXPNCN041635867	N	$0.00	$0.00	$0.00
102	102-2016-113	EXPAH1216116073	Y	$7.21	$2.10	$5.11	3032411
102	102-2016-100	EXPAH041638613	Y	$0.00	$0.00	$0.00
102	102-2016-112	EXPAHN1216104320	N	$0.00	$0.00	$0.00
102	102-2016-100	EXPAHN0416035701	N	$0.00	$0.00	$0.00
102	102-2016-112	EXPAHN1216104316	N	$0.00	$0.00	$0.00
102	102-2016-113	EXPAHN1216104316	N	$0.00	$0.00	$0.00	-
102	102-2016-100	EXPAHN0416035699	N	$0.00	$0.00	$0.00
102	102-2016-100	EXPAHN0416034443	N	$0.00	$0.00	$0.00
102	102-2016-113	EXPAHN1216100857	N	$0.00	$0.00	$0.00
102	102-2016-112	EXPAH1216108054	Y	$0.06	$0.00	$0.06	3061720
102	102-2016-112	EXPAHN1216099683	N	$0.00	$0.00	$0.00
102	102-2016-113	EXPAHN1216099683	N	$0.00	$0.00	$0.00	-
102	102-2016-102	EXPAH071670286	Y	$0.00	$0.00	$0.00
102	102-2016-100	EXPAH041636827	Y	$22.18	$16.82	$5.36	3028686
102	102-2016-112	EXPAH1216108472	Y	$9.02	$3.88	$5.14	3032411

[Gysbert_Wassenaar]

Replace the [Credit Amount] field with the expression =Sum({<Returnable={'Y'}>}[Credit Amount])

[Anonymous]

Try this....

[Anonymous]

it still shows the returnable

[Anonymous]

I meant to say it still shows the non returnable

[vinieme12]

You have to apply the same Set analysis to all the expressions

[Gysbert_Wassenaar]

Remove the Returnable field from the table if you didn't already.

[Anonymous]

I removed the returnable @gysbert wassenaar. I put the filter on the set expression under credit amount. It is still showing the returnable = N... I have one field that I concanated but otherwise it is just a straight table.

Thanks

[Anonymous]

I do not understand what you mean.. Do you mean i need to put this expression on all the measures on that particular table?