Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try like:
sum({<Month = {">=$(=Addmonths(Max(Month),-8))"}>}sales)
HTH
Sushil
Or May be this?
sum({<Month = {">=$(=Addmonths(Max(Month),-8)) <=$(=Date(Max(Month)))"}>}sales)