Rolling 12 Months HELP!

[#1]

Why is my expression giving me everthing and not just the past 12 months?

Getting really bored of trying to figure it out and all other posts are either going way over my head or i can't work out what i need to adjust to make them fit my report.

Any help will be much appreciated!

Elly

sum

({1<[HEADERS.Posting MonthEnd]={">=$(=addmonths(monthenddate(max([HEADERS.Posting MonthEnd]))+1,-12))

<=$(=max([HEADERS.Posting MonthEnd]))"}>}

{1<ITEM_UOM_GP.Brand={'2 DRAINAGE'}>}

{1<[ITEM_UOM_GP.Reporting UOM Sub Sub Group]={'Accessories'}>}

(Quantity )/1000)

[#2]

Good Morning Everyone!

It works!! It only blooming works!

With great thanks to Steve for pointing out the restrictions for Dimensions which led me to ask a new question of teh community.

And Nick who has created some awesome script which will provide very useful as i stumbled on how i can use it for another report i am using.

I created a blank expression to sort on first expression.

http://community.qlik.com/thread/47506

Thank you all again for your help.

Elly