12 months cumm. on single bar

[swatitomar]

Hey ,

i have 3 yrs data(2010,2011,2012) ..i want 12 months values in each bar..ex:

if i select Dec 2012 then  on first bar i want i.e

Mar2010 (i want starting 12 months data from Jan2010 -Mar 2010) and in next bar

Apr2010(i want jan2010-Apr2010)

-

-

-

Dec2010(Jan2010-Dec2010)

Jan2011(Feb2010-Jan2011)

[Gysbert_Wassenaar]

Please read these two documents:

• QlikCommunity Tip: How to get answers to your post?
• Preparing examples for Upload - Reduction and Data Scrambling

Then read this blog post:Accumulations

[HirisH_V7]

Try this:

RangeSum(Above(total Sum(Sales) , 0, 12))

Or else 12 steps accumulation

Hope helps,

Thanks,

Hirish