How to calculate YTD ?

[suvechha_b]

Hi All ,

How to calculate the YTD value in the below report.

Is , it possible to get YTD , month wise ? Like YTD Sales value from Jul to Jun 2017. See below snapshot.

sample model attached.

[MK_QSL]

Not exactly the same, but you will get some idea.

Calculating rolling n-period totals, averages or other aggregations

[hemanthaanichet]

Hi Bhadra,

Try this:

SUM({<Year = {$(=only(Year))}, Month = {"<=$(=num(Month))"}>} [Sales])

Regards

Hemanth

[shraddha_g]

Try:

SUM({<DateField = {">=$(=date(YearStart(max(DateField)))) <= $(=date(max(DateField)))"} , Month=,Year=,FiscalYear=>} [Sales])