General Acumulate

[#1]

Hi Everyone,

Actually i need the acumulate of all Historial

Year    Month    Salary

2016      1          1000

2016       2        2000

2015     12         1000

2015     11          3000

When I Chose the Year 2016 and month 2  i need:        

Salary of month 2: 2000 + Salary of Month 1: 1000  +Salary of Month 12: 1000 + Salary of Month 11: 3000

Other Example:

When I Chose the Year 2016 and month 1  i need the Acumulate of:  

Salary of Month 1: 1000  +Salary of Month 12: 1000 + Salary of Month 11: 3000

the acumulate of rest of the months including the last year

Some Any Idea please???

[hirenjadiya · Accepted solution]

Hi Omar,

Please find attach the solution.

Other then you Table information I have created 1 extra field "YearMonth" and 1 variable "vYearMonth" which hold the selection value of YearMonth.

Hope it is helpful to you.

[Anil_Babu_Samineni]

I need to ask you one thing

If you select 2016 .the data should associate only 2016, right?

This scenario why do you require to get 2015 data for 12th and 11th month from 2015

[#4]

Hi Anil Babu good day,

What i mean is that if  i choose any year for example 2016 i need all information from 2016 and the historial of the rest of the years 2015, 2014, etc,etc.

If i chose 2016 and any month February then i need information from 2016, 2015, 2014 and from months febrary 2016, January 2016, December 2015, November 2015....All Historial

Best Regards

[#5]

Perfect Really Tahnks God Bless you SOOO muchhhh thanks you make me happy!!! Work it Perfect