Need help for Function YTD

[tomhovens]

Hello all,

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

=Sum({$<Month=>}amount)

[sunny_talwar]

Have you checked out this blog -> YTQ, QTD, MTD and WTD

[Gysbert_Wassenaar]

Perhaps these blog post help:

Year-over-Year Comparisons‌

Relative Calendar Fields

[#4]

Hi

Whatever filter you want on sum you can add as you added Month.

eg.

=Sum({$<Month=>,Year=>}amount)

like wise. it will just ignore your selection and show the sum.

Regards,

Lokesh