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

# 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,

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

and the sames with charts (lines) to see the increase

• ###### Re: how to create table calculating previous, current and first values of month?

Hi,

What ever i am able to do is in this example.

Hope this will help you

Regards,

Kaushik Solanki

• ###### Re: how to create table calculating previous, current and first values of month?

We managed to do this, before is not enough for calculation from the first period, but thanks for help (2 Kaushik.solanki).