YTD,QTD weeknumber Calculations

[#1]

Hi All,

I have Yearweek available in my calendar. I want to compare this Year YTD Vs Pervious year YTD.

Same for QTD as well.

i want to calculate values for all weeks here.

Can anyone help me to how to extract YTD for all weeks.

Thanks

Khushboo

[adamdavi3s]

What are you using as your stopping point, i.e. if you want to see YTD in weeks, do you do all weeks until the last Sunday for example?

If you reload daily then calculating a YTD & PYTD flag in the calendar script is really the best way to go (IMHO) as you can simply use this in set analysis then