2 of 2 people found this helpful
Tableau (and Tableau Prep) know how to create a date hierarchy and how to sum data - just include the monthly data (not the quarters or the ytd) -
Pivot the data so there is a date column (with a real date not just a month like 8/1/18 for August) you can do that in Prep after the data is loaded and recast as a date
it will solve both your issues
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.