Hello Team ,
I would like to get total sales for last week
With a week starting Saturday (10/14/17)
End date Sunday 10/22/17
Thanks for your help
.
3 answers
Thanks for your reply here is more details; I am trying to display
Last Week total cnt from last Saturday to Sunday (10/21/17 to 10/29/17) I want to refresh this dynamically without hard coding the dates.
like I did for the calculation below.YTD: Year to date
if(YEAR([Metric
date])=YEAR(TODAY()) )then
[Total Cnt]
end
MTD: Month to date
if (MONTH([Metric
date])=MONTH(today()))then
[Total Cnt]
end
Yes: Yesterday
if([Metric date]=(TODAY())-1
and NOT ISNULL([Total Cnt]))then
[Total Cnt]
End
Last Week ??????
See the sample output of my data.
