set analysis

[#1]

Hi

I want to use set analysis for FTD,MTD,YTD calculations.

If anybody can provide script for this,would be great !

Regards

Praveen

[#2]

Hi Praveen,

Below code will help you to do the requirement.

MTD = sum({$<Month_Year={"$(=monthname(today()))"}>} Sales)

YTD = sum({$<Fin_Year={"$(=(yearname(today(),0,10)))"}>} Sales)

Regards

Sridhar