How filter different form dataitemtableview

markyT

Hello, I've a report with the "Item Ledger Entry" table as a dataitem. On DataItemTableView, on Table filter, I filter by Purchase in "Entry Type" field.
In sections, in a footer, I want that it filter by Sale in "Entry Type" field, only in this section. But it doesn't works I suppose because it has Purchase on filter from Dataimtetableview. I've try put the code "Item Ledger Entry".SETFILTER("Entry Type", 'Sale'); on PreDataItem from "Item Ledger Entry" dataitem and on Presection from footer section but it doesn't work. How can I do that please?.
Thanks.

mohana_cse06

why dont you use one more tempILE table for this?
:-k