current week's date

[#1]

Hi Experts,

i have a date field called 'ORDEREDDATE'.

In my pivot table, i want to display current week's dates alone.

i tried the dimension as date(week(max(ORDEREDDATE))). but i m getting error.

can someone help me to correct the expression please..

[sunny_talwar]

How about this:

If(ORDEREDDATE >= WeekStart(Today()), ORDEREDDATE)

and select 'Suppress When Value Is Null'

[sunny_talwar]

Alternatively you can use Set Analysis as well

{<ORDEREDDATE  = {"$(='<=' & Date(WeekStart(Today()), 'DateFieldFormatHere'))"}>}

Assuming you don't have dates in the future.

[#4]

Hi Sunny,

Instead of Weekstart(Today()), how can i do this for Max(ORDEREDDATE)

[sunny_talwar · Accepted solution]

May be this:

If(ORDEREDDATE >= Max(TOTAL ORDEREDDATE) - 7, ORDEREDDATE)

[trdandamudi]

May be this: (I modified Sunny's expressions):

If(ORDEREDDATE >= Max(ORDEREDDATE))

Or in Set analysis:

{<ORDEREDDATE  = {"$(=Max(ORDEREDDATE))"}>}