Rolling 6 Months based on Month Selected

[#1]

Hi Dear QV Community

I have the "Rolling6Months.qvw" with a table info i need sum the last six months based on month selected.

Example: If I Select Nov 2012 The Second Expresion of Pivot table and TextObject make a sum of sales from Jun2012 to Nov 2012

Regular Expression: =Sum({<DescTarifa=>} [Vta Neta])

Please download the QVW attachement

[sushil353 · Accepted solution]

Hi,

PFA

HTH

Sushil

[#3]

Thanks works fine for me !!

[rajni_batra]

Hii ,

i also have similar kind of requirement, i want 6 month rolling on MOM basis,

If i am selecting Nov it should show data of past 6 months which is already done in ur sample app but if i diaplay it on month basis it displays past 6 months also but here i want single month NOV displays data for 6 months , is this possible ?

[tresesco]

PFA. Hope this helps.

Thanks.

[rajni_batra]

as in 2nd expression in table 645 is sum of last six mnths , same output i want in MoM i.e. on selction of DEC 13 it should give 645 in chart also but on x axis it should show only dec not all last 6 months.

Hope it clear my requirement

[tresesco]

PFA

[rajni_batra]

No , I want single bar showing sum of all 5, please see the screenshot attached

[tresesco]

Did you check app 2?

[rajni_batra]

Yes, i have sent scrrenshot from app 2 itself, Please send if there is any updated version.