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.

       

      Thanks.