Hello Alora

This blog post details how to compare any time period with another period N years/months in the past:

http://interworks.co.uk/blog/date-comparisons-tableau-made-easy/

let me know if you can't get an answer to your question from there.

Thanks

Steve

Hello

It's on my profile here:

Steve Taylor

Thanks

Sorry, had my privacy settings wrong, try now?

Alora Omega, it's best to simply attach your packaged workbook here in the forum.  This allows others to help you work out a solution.  The forums here are for group help and learning.  This way the help conversation does not go off-line and everyone can see when an answer is reached.  Everybody wins.

Thanks Toby

Provided there was nothing sensitive in the workbook I was planning on posting the solution (if I found one!) here.

Steve

Hello again.

EDIT I've removed the attachment at Alora's request but I've added to the explanation.

I've added two tabs, one that shows the date range selection working (Example Date Range Calc) and one that replicates the table you started with but with the two calculated fields I added which work out the LV_Total for the selected current period and the same period last year (LVdata table)

I created a number of months parameter and kept your End Date parameter so that the user can select the end date (which is truncated to the 1st of that month in the calculation so data is provided UP TO the start of the month to maintain whole months for the date range) and the number of months up to that date to show (I set it to six but you can play around with it).

I've annotated the calculations LV_Total_CurrentPeriod and LV_Total_PrevPeriod to explain what's going on, here is LV_Total_CurrentPeriod:

This basically says if the date is before the 1st of the month selected in the End Date parameter AND it's after the specified number of months prior to the end date then include the LV_Total value (NOTE the Prev_LV_Total field is a database field that holds all LV totals).

And here is LV_Total_PrevPeriod:

The date range can be seen to work below:

Please let me know if that doesn't solve your question.

Thanks

Steve

You're very welcome.

Steve

Good work, Steve