Graph showing past 1 year changing to last 8 months

[kiranpatil123]

Hi all ,

Need help on this.

I have a  Bar graph which shows Target Days for last one year ( from April 16 - march 17) . I need to change the graph showing from last 8 Months till present Month ( Aug 16 - march 17). In Dimension I have used Fiscal Month  

Thanks and regards

Kiran

[sushil353]

Try like:

sum({<Month = {">=$(=Addmonths(Max(Month),-8))"}>}sales)

HTH

Sushil

[Anil_Babu_Samineni]

Or May be this?

sum({<Month = {">=$(=Addmonths(Max(Month),-8)) <=$(=Date(Max(Month)))"}>}sales)