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

[#1]

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,

[#2]

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

[kaushiknsolanki]

Hi,

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

     Hope this will help you

Regards,

Kaushik Solanki

[#4 · Accepted solution]

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