Set Analysis Issue

[rahulsingh12]

Hi,

I have a set analysis expression to calculate the YTD but it is just giving me MTD data instead.

if(UniqueId_Flag='1',

sum({<Year={"$(vYTDCurrentYear)"},Month={"<=$(vYTDMinMonth)"}>}([CostPerUnit )),

sum({<Year={"$(vYTDCurrentYear)"},Month={"<=$(vYTDMinMonth)"}>}[Variance]))

vYTDCurrentYear=Current YEar

vYTDMinMonth=Current Month

Regards,

Rahul

[svinnakota]

can you post a sample app along with the data

Santosh

[ajaykakkar93]

hi try this link

Date Level Analysis - WTD, MTD, QTD &amp; YTD (Current Year &amp; Previous Year)

[ajaykakkar93]

hi i have made a small example by my understanding