WTD

[#1]

Hi,

I want to show up the values in Week to date eg., sum of sales till week to date.

Can some one help me with the formaulae.

Many Thanks,

Swathi

[#2]

Him

try this

week(date field)

[ferha_jafri]

Try this :

sum({<Year={'$(=max(Year))'},Month={'$(=Max(Month))'},Week={'$(=Max(Week))'},Date={'<=$(Max(Date)))'}>}Sales)

this will give you WTD

[#4]

But Max of week is giving last week ie., 52nd week, which is not the WTD right?

is it Week={'$(=week(today()))'}?

Correct me if i'm wrong.

Thanks,

Swathi

[CELAMBARASAN]

Check this link     YTQ, QTD, MTD and WTD

Hope it helps

[ferha_jafri]

No , it will give you max month max week , i.e the month you select.