6 Replies Latest reply on Nov 1, 2012 7:52 AM by Diarmuid O'Connor

    Dynamic Sort on current day

    Diarmuid O'Connor

      I have a weekly sales report which is going to be dynamically refreshed.

       

      The report shows the number of sales for each sales person for each day of the week.The data source for the report is a SQL query, which breaks the sales down for the week, always using Monday as the start day. Therefore if the report is run on Tuesday, it will only have 3 columns (Sales Agent, Monday, Tuesday) whereas if it is run on Friday it will have 5 columns (Sales Agent, Monday, Tuesday, Wednesday, Thursday and Friday).

       

      I want the report to always sort by the highest number of sales for the 'current' day. How do I do this if I don't know which columns I will have in my report?