There are 2 ways, one is to use a parameter rather than filter for the month selection. And the other way is to join your data to itself using the key a.[month] = dateadd('month',1,b.[month])
Not sure which one you would prefer to?
Thks for the reply ZZ
Kindly elaborate your solutions please. I think I’ll prefer the one without using parameter.
I assumed your solution is not creating the calculated field on the back end table before importing into TB? This is not what I’m looking for. I prefer a solution that is within Tableau.