how to show latest 24 months of data in chart?

[udaya_kumar]

Hi,

I have a date field in the chart as x-axis.

Currently am showing 72 months of data, the full data.

now i want to show only latest 24 months of data in the x-axis in the chart.

how we can do that?

[udaya_kumar]

Jason,

It is not working

This is the expression am using

sum({<MONTH_START_DATE={"<=$(=Date(AddMonths(Max(MONTH_START_DATE),-vMonth),'MMM YYYY')"}>}TRx_Volume)

What is the problem here?

[udaya_kumar]

It is showing,

No Data to Display on the table.

only({<MONTH_START_DATE={">=$(=Date(AddMonths(Max(MONTH_START_DATE),-vMonth),'MMM YYYY')"}>}TRx_Volume)

This is the expression i tried, but also not working

[Jason_Michaelides]

Post your app and I'll take a look.