Rolling Six Months

[offjunior]

Good morning friends!

I'm trying to make a kind of rolling, where I always do a sum of the last six months, but grouping by other fields. However I do not know how to add up the last 6 values ​​do not follow. In practice is the following, I have a column called "date" (dd / mm / yyyy) which is one of the dimensions is another dimension column "Site Name", the other columns are expressions, all this in a Pivot Table . I wanted to add the last six months for each "Name Location" specific. Perhaps the image can illustrate what i need.

Attached hereto, an image, a QVD files with data and application.

Thank you all!@

[offjunior · Accepted solution]

Hello friends!

I had no answer here in the community, however I got the solution to my problem, where only one is needed to do in my script that made the reading of my table by adding and grouping the values ​​of 6 in 6 months. If anyone needs the solution, I am available.

Thank you!

[mphekin12]

Junior Junior,

I am facing a similar challenge where I am trying to get a sum of the last 12 months of sales based on Divisions.  Can you post your solution as it may be helpful!

Thank you.

[offjunior]

Good afternoon friend!

Extracts a small part of my application to send you an example that is more concise easier for your understanding ... I tried to put some comments in English, in the script to help you ...

Hope this will help you with your problem.

Big Hug!

[mphekin12]

Thank you!

[punitpopli]

Hi offjunior

I am facing similar kind of problem but for weeks in my project.

Could you please share the solution which you have implemented in your project  in English please?

[offjunior]

Good morning!

In the previous post their exists a file with my solution.

See if this meets you.

Thank you.

[punitpopli]

Hi offjunior,

The text file you have added is not in English.

Could you please add the sample script file which you have implemented in English?

Thanks in advance,

Punit

[offjunior]

Friend, some comments are already in English out, what it is not, please use Google Translate. For better understanding, paste the text into your script editor.