Previous Month sales value Assigning to a Variable

[Anonymous]

Hello all,

I am having Master Calender, now I have to assign last 6 month to six variable on the basis of Calender selection.

Example: FYear, FMonth in Calender

Say user selects April 2014

then my variable should have like this:

V1= April 2014

V2= March 2014

V3= Feb 2014

V4= Jan 2014

V5= Dec 2013

V6= Nov 2013

Pls suggest.

Regards,

Balraj

[anbu1984]

Check this qvw

[Anonymous]

Anbu,

Will it capture those month which comes into next or previous year??

[Anonymous]

Say,

I am having 2013 year as well,

if I selects Dec 2013, will it give Jan 2014???

[anbu1984]

Yes it will give Jan 2014

[krishna20]

Dear Balraj,

Please find the below attachment what you are looking for. i just modified anbu cheliyan APP.

Regards

Krishna

[#7]

Dear Balraj,

Use AddMonth function for this functionality.

This function is very useful for these kind of functionality.

For Exp:-v1:-month

v2=addmonth(month,-1)

v3=addmonth(month,-2)

v4=addmonth(month,-3)

v5=addmonth(month,-4)

v6=addmonth(month,-5)

AddMonth automatically transfer to last year.

for e.g if year is Jan-2014 then automatically it does Dec-2013.

Thanks & Regards

Prince Anand

[Anonymous]

Krishna,

I have edit it and added sales of the month as well.

Could you help me to get the sales of these month as well in similar fashion.

Say,

If I select Jan 2014 then It should give me the sales of last 3 month

Jan 2014 Sales:100

Dec 2013 Sales:128

Nov 2013 Sales:500

like this......

[Anonymous]

I have uploaded your sample file by editing it.

[Anonymous]

Prince,

It will pick garbage value in this case..........