Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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