I need syantax to get Last six months data?

[sureshbn121]

Pls send me ...

[timpoismans · Accepted solution]

I take it you want to limit the load in your script?

Do you have a date field?

Do you take the current month as part of the six months, even though it's not complete?

Give us a bit more info so we can help you out.

[justinphamvn]

Hi,

May try like this:

// Sum Last six months Sales

sum( 
          { 
              < 
                date=, 
                Year=, 
                Month=, 
                Quarter=, 
                    date={">=$(=AddMonths(Max(date),-6))<=$(=Max(date))"} 
              > 
          } 
Sales) 

Hope this helps,

Justin.