1 Reply Latest reply: Jun 12, 2013 12:03 AM by sujeet Singh RSS

    Filtering rows

      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.