YTD Help

Hi,

So I am trying to calculate a YTD for a given month.

My data looks something like this (over simplified)

Cost Period

2      June 2018

3      July 2019

4      April 2019

1     March 2018

Now, I start by selecting a period, say for example June 2018

I then want to calculate the YTD on the page as well, not when I use TOTALYTD as the table has filtered down to June 2018 only, the period sum matches the YTD sum and does not include March 2018.

How can I get the YTD to ignore the date filter on the table, but at the same time decide to look at the financial year of 2018 due to the fact that June 2018 is selected/

Many thanks!

Jese