scenario

[#1]

Hi friends,

Product_id	Date	amount
A	1/5/2013	100
A	1/6/2014	200
A	1/7/2015	300
B	1/7/2013	200
B	1/8/2014	300
B	1/9/2015	400

this is my table here my requirement how to get last 2 years total(100+200)=300

as well how to get last 3 years amount 600

how to achieve this , please help me on this

[MK_QSL]

Do you want this at back end?

If front end, where you are going to use this?

In chart or in text box?

[Anil_Babu_Samineni]

What was the expected output? Does this happen with Product wise or what? Would you describe more

[#4]

Hi Manish,

his requirment is

Product    2 years                       3 years

A               (100+200)= 300          100+200+300

B        same like A .

in front end only.

[#5]

his requirment is

Product    2 years                       3 years

A               (100+200)= 300          100+200+300

B        same like A .

in front end only.

[#6]

Could you suggest me best material for Set analysis. and performance improve steps.

[#7]

Could you suggest me best material for Set analysis. and performance improve steps.

[Anil_Babu_Samineni]

His means (User)

Can you try something like this

241345:

LOAD * Inline [

Product_id,  Date1,    amount

A, 1/5/2013, 100

A, 1/6/2014, 200

A, 1/7/2015, 300

B, 1/7/2013, 200

B, 1/8/2014, 300

B, 1/9/2015, 400

];

Final_Table:

NoConcatenate

LOAD *,Right(Date1,4) as Year

Resident 241345;

DROP Table 241345;

Take Straight Table

Dimension is -- Product_id

For 2 Years -- Sum({<Year = {"$(='<' & Max(Year))"}>} amount)

For 3 Years -- Sum(amount)

Seems O/P this, For Ref, Enclose is attached

[simran04]

Please try the below code:

INPUT:

LOAD * INLINE [

Product_id,Date,amount

A,1/5/2013,100

A,1/6/2014,200

A,1/7/2015,300

B,1/7/2013,200

B,1/8/2014,300

B,1/9/2015,400

];

INPUT1:

LOAD Product_id,

SUM(If((Year(Date#(Date,'DD/MM/YYYY'))='2013' OR Year(Date#(Date,'DD/MM/YYYY'))='2014'),amount,0)) as twoyearssum,

Sum(amount) as Threeyearssum

resident INPUT

group by Product_id;