Formula to calculate last week sales in Sage Enterprise Intelligence

SOLVED

Hello Team,

Can anyone help with formula to calculate last week sales in SEI and also compare last year sales and current year sales.

Thanks.