6 months

[raadwiptec]

I need an expression to just display the last 6 months data only on my staright table..I have a Month and year column

[raadwiptec]

yes i need with date ..can ypu give me the full expression for date..  as i dont want to hard code .. it should be dynamic..today - 6 months

{< Year = {$(=Year(Today()))}, Date=>}.

[raadwiptec]

and secondly should date be one of the dimensions or expressions in the chart?

[ramchalla]

Hi Raadwiptec,

Try the below expression.

=SUM({<Date = {">=$(=Addmonths(Max(Date),-6))<=$(=Max(Date))"}>} Sales)

[jmvilaplanap]

Try with this:

• {< Year = {$(=Year(Today()))}, Date={">=$(=addmonths(today(),-6))"}>}

And not is necesary that the day (or date) be on the chart (as expression or dimension)