So I am trying to calculate a YTD for a given month.
My data looks something like this (over simplified)
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/
Join us in the third Triple A event!
It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.
Make sure you didn't miss any of the things that happened in the community in January!