Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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?
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
Post your app and I'll take a look.