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 |
| | | | | | |
| | | | | | |
