I have come across this excel report where there are mix calculation type.
I also attach the image of my requirement. I wonder if I can put all this calculation in one worksheet?
or what is the best solution to do this on Tableau.
Seems difficult to put them on one worksheet.
A workaround could be dashboard.
For example, create three worksheets for 1) YTD by month, 2) Sep 16 - Sep 15, 3) YTD by year, and put these three on one dashboard.
Retrieving data ...