2 of 2 people found this helpful
This can easily be done by creating an offset date from below calc. Use this ONLY IN FILTER SHELF as relative date. Then put the Year of the original non-calculated date dimension on the color shelf. You can then adjust for last how ever many days you want and it will show you by year (on a line chart or text table). I hope this helps.
I want that data in cross tab....can please guide me in brief step by step. i have date field and sales value and product category field....