You can try something like this. Drag this calc field in filters shelf and filter 1 to 3.

Hope this help.

Mahfooj

Hi Shaji

You can do it multiple ways...

Something like this is also possible - working example attached, suing Superstore (v9.3.5)

logical test if date is last 3 days (dates must be pre-sorted by date)

LAST() >= 0 and LAST()<3

That will return true for the last 3 days, then use that calc, to leverage your sales...

• sum = IF [last 3 days] THEN SUM([Sales]) END
• avg = IF [last 3 days] THEN AVG([Sales]) END

Hope that helps!

Cheers

Mark

Shaji, out of interest, which method did you use?