4 Replies Latest reply: May 24, 2011 8:42 AM by Claudia Zwick RSS

    Compare the same field in one table

      Hi everybody,

       

      I have one table with the following informations:

       

      %item, %week, stock

      23, 13, 1234

      24, 13, 145

      24, 14, 458

      25, 14, 1547

      23, 15, 2458

      25, 15, 147

       

      Now I want to compare the weeks to find the difference to show it in a bar chart:

       

      item, 13, 14, 15

      23, +1234, +0, +1224

      24, +145, +313, +0

      25, +0, +1547, -1400

       

      That are the start result for every week. I can also find out the end result for every week, if I need to. Maybe I need to, or?

      But how compare I this week with the week before without selecting one week out? Without something like, week(today()) and week(today()) - 1.