Chart on the last 12 months

[Anonymous]

I want to show last 12 months in calculated dimension from current month.

[tresesco]

Put months on dimension and expression using set analysis like:

sum({<Date={'>$(=monthstart(max(Date),-12))'}>}Amount)

[its_anandrjs]

Hi,

Try this if you have any Month Year Field

=SUM({<[Month Year]= {'>=$(=(Max([Month Year])-12))<=$(=Max([Month Year]) )'}>}Revenue)

Regards

Anand

[rubenmarin]

Hi, you need to ignore selections on date related fields and limit the values for the last 12 months

Sum({<Year,Quarter,Month,DateField={'>$(=MonthStart(max(DateField),-12))<=$(=max(DateField))'}>} ValueField)

[kavita25]

Hi,

Using Set Analysis in your expression and dimension can be month or MonthYear field  :

sum({<DATE={'>=$(=MonthStart(Max(DATE),-12))<=$(=MonthEnd(Max(DATE),-1))'}>}amount)

[#6]

add calculated dimension

if(date(date_column,'D/M/YYYY') > date(ur_date, 'date_format') and  date(date_column,'D/M/YYYY') < date(ur_date, 'date_format'), date_column, null())

date_column is dimension field

ur_Date - u can keep date static or dynamic

[its_anandrjs]

Another One way is

And in dimension Take MonthYear Field

Expre:-  Sum({<Date ={'>$(=((AddMonths( Max(Date),-11))))<=$(=( Max(Date)) )'}>} Sales)

Regards

Anand