Year to date calculation on Pivot table in a way that is filterable

Hi Team,

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.

Is this possible to do in Metabase?

Thanks,

Adeesha