2 of 2 people found this helpful
These depend somewhat on how you want to display the data as well. For example, if you want to do calculations showing difference between the two time periods, then a calculation like the following can help;
But if you want a line chart over this period between the parameters, and another line showing the data from this period last year, then it's a bit more tricky and you have to 'trick' tableau into thinking these both have the same 'Order Date'.
Or just have your axis on Months, and put the year of Order Date on the color control on the Marks card to differentiate between the two periods.
Again, this all somewhat depends on your final visualization, but I hope this helps a little.
1 of 1 people found this helpful
You made my day :-) "Last Year Sales" works perfectly fine !
Thanks so much, have a great day !