I'm looking for a function to calculate the YTD of amount but:
- Peolpe can make a selection on the month doesn't change the outcome of the function
- People can choose the country does change the outcome of the function
This is the function I have till now
Have you checked out this blog -> YTQ, QTD, MTD and WTD
Perhaps these blog post help:
Relative Calendar Fields
Whatever filter you want on sum you can add as you added Month.
like wise. it will just ignore your selection and show the sum.
Retrieving data ...