topic Re: How do you put a filter in a table in App Development

How do you put a filter in a table

Anonymous — Mon, 26 Mar 2018 15:17:10 GMT

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

Re: How do you put a filter in a table

Gysbert_Wassenaar — Mon, 26 Mar 2018 17:00:28 GMT

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

Re: How do you put a filter in a table

Anonymous — Mon, 26 Mar 2018 17:06:24 GMT

Try this....

Re: How do you put a filter in a table

Anonymous — Mon, 26 Mar 2018 23:25:49 GMT

it still shows the returnable

Re: How do you put a filter in a table

Anonymous — Tue, 27 Mar 2018 00:48:39 GMT

I meant to say it still shows the non returnable

Re: How do you put a filter in a table

vinieme12 — Tue, 27 Mar 2018 01:56:54 GMT

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

Re: How do you put a filter in a table

Gysbert_Wassenaar — Tue, 27 Mar 2018 06:15:55 GMT

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

Re: How do you put a filter in a table

Anonymous — Tue, 27 Mar 2018 13:21:33 GMT

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

Re: How do you put a filter in a table

Anonymous — Tue, 27 Mar 2018 13:22:34 GMT

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