Comparing periods in line chart

[dafnis14]

Hi,

I need to compare sales periods for a product, for a sale period that crosses 2 subsequent years, in a line chart.

On the X axis i have the sales date in DD-MMM format.

The Year dimension is no good because it will not show the sales for 2 years in the same line.

How can i define the correct period dimension in order to compare them?

Thanks!

[HirisH_V7]

Hi ,

Check this, is this what you required!!,

By creating a Date Field in Script and a Calculated dimension in Chart for only last two years .

=Aggr(Only({<Year={'$(=Max(Year))','$(=Max(Year)-1)'}>} Year),Year)

HTH,

PFA,

Hirish