3 Replies Latest reply: Jun 9, 2011 5:19 AM by Alexander Gonchar RSS

    how to create table calculating previous, current and first values of month?

      The tast is to calculate turnover and quantity of good by different periods and it's dynamics form the firs period and from previous,

      to see how values change.

      so in a table we need to calculate by products/stores (2 demension in a group for a fast change in table) and periods (day/week/month/year in a group - change is also allowed).

      1) turnover

      2) quantity

      3) increase of turnover/quantity from the first period in  absolute value.

      4) increase of turnover/quantity from the previous period in  absolute value.

      3) increase of turnover/quantity from the first period in  %.

      4) increase of turnover/quantity from the previous period in  %.

       

      see table as example,