4 Replies Latest reply: Dec 12, 2011 12:11 PM by Boris Nechaev RSS

    Reversed straight table.

      Hello!

       

      I have a horizontal straight table with date as dimension. The task is to show 7 latest days. The solution is simple: sort the date in descending order and set 'Max number' in 'Presentation' tab to 7. This shows 7 days decreasing from left to right.

       

      The problem is that a client repeatedly asks to show the newest date to the right, not left. How can I do this? If it would be a bar chart, I could have selected 'Reversed' option in 'Presentation' tab, but alas there is no such option for straight table.

       

      If it's not possible to do this with the table settings, perhaps someone could suggest an expression for the calculated dimension that will do the job.