Hi,

[#1]

how to calculate the YTD Sales and MTD Sales, QTD Sales but Make sure my calendar year starts with the 1-OCT.

Thankyou,

Siva

[adamdavi3s]

Hi Siva,

Use a master calendar with flags, check out the search box at the top right, it will help you a lot

[sasikanth]

HI,

There are some functions available to compute .

1) YearStart(), YearEnd()

  Sum({<Date={">= $(=YearStart(max(Date)) ) <= $(=max(Date)) "},YEAR=,MONTH=>}SALES)

2) MonthStart(), MonthEnd()

  Sum({<Date={">= $(=MonthStart(max(Date)) ) <= $(=max(Date)) "},YEAR=,MONTH=>}SALES)

3) Quarterstart(), QuarterEnd()

Sum({<Date={">= $(=QuarterStart(max(Date)) ) <= $(=max(Date)) "},YEAR=,MONTH=>}SALES)