Last 10 days in a graph

[#1]

I am trying to get another graph to show just the last 10 days of data

My Date field is ReportDate.  The attached seems to bring through every day in 2014 and not just the last 10 days.

ideally I would like to remove the year part so when we are on the 2nd Jan 2015 it will show 8 days worth of December also.

sum({<Year={$(=Max({1}Year))},ReportDate={">=$(=ReportDate(Max(Reportdate)-10)<=$(=ReportDate(Max(ReportDate))))"}>}RenewedCounter)

[ashwanin]

Hi Rodney,

Please provide the dummy sample data.

[#3]

Was there meant to be an attachment?

[#4]

Hi Rodney

why don't you simply use Dimension Limit ?

Best regards

Chris