Filtering rows

[#1]

I want to filter bunch of rows in a straight table based on  'no of offset days'  and show sales amount for that particular date.

So a user can select 10 (or 20 from a drop down) and table should ONLY SHOW RECORDS  where sales_data = sales_date - 10 and sales_amount should show sales for that particular date for that record.

Something like Sum($<sales_date={=$(sales_date)-$(vOffset)}>Sales)

Any help will be appreciated.

Thanks.

[sujeetsingh]

Hi,

You can assign a Variable and then include that variable in your set analysis expression .