I have attached a sample worksheet. In this worksheet dates are hardcoded for last 2 days average. I do not want to hardcode but calculate average based on last 5 business days(Weekdays) and monthly average based on last 30 business days.
15 answers
Here is one idea.
[Filter with Param]
if [ReportDate]=attr([Date]) then index() end
Thanks,
Shin
