Is there a way to create a YTD calculation on a datasource and then render the results as a pivot table? I'd also like to be able to use linked filters on this question, which means that I need to construct the question using the GUI, instead of using SQL.
Late reply, but it should be achievable in Metabase. Create a model to perform the YTD calculation (using cumulative sum or whatever method you use) then summarize it in a question using the dimensions you want to pivot around.