Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a chart that I need to make static (does not change with selections made). This is the expression I am using but I cannot seem to fix it. Is there any way to use set analysis to keep it fixed?
=If(Week([Date Created On]) = Week(Today())-1,count([Material Description]))
The expression shows how many SKUs were created the past week.
Any help is greatly appreciated!
Thanks!
count({1<WEEK={'>=$(=max(WEEK)-1)<$(=max(WEEK))'}>}[Material Description])